wrote:
for your info only
-- Forwarded message --
From: STDEV(i) setiyowati.d...@gmail.com
Date: Fri, Mar 4, 2011 at 5:40 AM
Subject: Re: $$Excel-Macros$$ Pls Help me in the attached file
To: excel-macros@googlegroups.com
why not
=SUMPRODUCT(
('Closing Price'!$B$2:$B
--
From: STDEV(i) setiyowati.d...@gmail.com
Date: Fri, Mar 4, 2011 at 5:40 AM
Subject: Re: $$Excel-Macros$$ Pls Help me in the attached file
To: excel-macros@googlegroups.com
why not
=SUMPRODUCT(
('Closing Price'!$B$2:$B$3473=$A16)*
('Closing Price'!$D$2:$D$3473=LEFT(B$15,2