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
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
Last edited by SelC; 07-25-2011 at 05:55 AM.
=SUMPRODUCT(--(Sheet1!A2:A35="Urgent"),--(Sheet1!B2:B35="x"))
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Another option:
=COUNTIFS(Sheet1!A2:A35, "Urgent", Sheet1!B2:B35,"x")
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"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks