SUMPRODUCT multiple worksheets

**SelC** · 07-25-2011, 02:49 AM

Hi!

I tried to use SUMPRODUCT but the result is #VALUE!, and how can i add a criteria where the source data from sheets..3..4.

=SUMPRODUCT(--(Sheet1!A2:A35="Urgent"),--Sheet1!B2:B35="x!")

Thanks!
Selc

**TMS** · 07-25-2011, 03:30 AM

=SUMPRODUCT(--(Sheet1!A2:A35="Urgent"),--(Sheet1!B2:B35="x"))

Regards

**Colin Legg** · 07-25-2011, 04:08 AM

Another option:

=COUNTIFS(Sheet1!A2:A35, "Urgent", Sheet1!B2:B35,"x")

**SelC** · 07-25-2011, 05:56 AM

Great both works perfect!

I can add also a criteria where I need the result per month from source data.

=SUMPRODUCT(--(Sheet1!A2:A35="Urgent"),--(Sheet1!B2:B35="x"),--(Sheet1!B3:B35="JULY-10"))