Sumproduct for multiple months

[Alice21]

Hi

I am using the below formula to calculate how many staff have been sick in April 2010 with cold/flu.

=SUMPRODUCT(--(TEXT(ARCHIVE!$H$4:$H$10000,"MMMYYYY")="APR2010")*(ARCHIVE!$G$4:$G$10000="Cold/Flu"))

Is there any way I can extend this formula to calculate how many staff have been off with cold/flu in April, May and June?

Thanks

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.

[NBVC]

Try:

=SUMPRODUCT(--(TEXT(ARCHIVE!$H$4:$H$10000,"MMMYYYY")={"APR2010","MAY2010","JUN2010"})*(ARCHIVE!$G$4:$G$10000="Cold/Flu"))

or

=SUMPRODUCT((YEAR(ARCHIVE!$H$4:$H$10000)=2010)*(MONTH(ARCHIVE!$H$4:$H$10000)>=4)*(MONTH(ARCHIVE!$H$4:$H$10000)<=6)*(ARCHIVE!$G$4:$G$10000="Cold/Flu"))

[Alice21]

Thank you so much, I think that has worked!