PamelaJ wrote:
I'm trying to sum information on another worksheet.

01-Jun in column a and 15 in column b
25-Jun in column a and 20 in column b
01-Aug in column a and 30 in column b

to give me total for Jun in another worksheet with a total value of 35
(ie adding just the month of June

Can anyone help?


--
PamelaJ
------------------------------------------------------------------------
PamelaJ's Profile: http://www.excelforum.com/member.php...o&userid=36387
View this thread: http://www.excelforum.com/showthread...hreadid=561701

Hi Pamela,

Maybe you can use SUMPRODUCT() Something along the lines of:

=SUMPRODUCT(--(MONTH(A1:A3)=6),B1:B3)

Asuming here that the Dates are in A1:A3 and numbers in B1:B3.
Jou can just modify the range to your needs.
The 6 is for June and you can just alter that aswell to fit your needs.

Regards,
Bondi