Hi,

Thanks a lot..

DA

Toppers wrote:
Use SUMPRODUCT:

For date of 1st July 2006:

=SUMPRODUCT(--(A1:A5=DATE(2006,7,1)),--(B1:B52))

or month of July:

=SUMPRODUCT(--(Month(A1:A5)=7),--(B1:B52))

HTH

Hi,

[quoted text clipped - 29 lines]
Thanks,
Dinesh Advani

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1