SumProduct Error

[ultracyclist]

Hi,

I'm having problem with a SumProduct formula and do not understand why its not calculating correctly. I'm using the following formula. The formula should return a total count of 150 for the GH 372 devices

=SUMPRODUCT(G2:G81,"GH 372",H2:H81,">0")

I tried CountIfs and SumIFS formulas with the same criteria and no value is being returned.

Thoughts??

Thanks,
Tom

 

[Peter_SSs]

That is definitely incorrect syntax for SUMPRODUCT

COUNTIFS should work though provided you are just trying to count how many rows meet those two criteria.

22 02 12.xlsm
	G	H	I	J
1
2	abc	1		2
3	GH 372	2
4	GH 372	0
5	GH 377	4
6		5
7	abc	6
8	GH 372	7
COUNTIFS

Cell Formulas
Range	Formula
J2	J2	=COUNTIFS(G2:G81,"GH 372",H2:H81,">0")

If that is not what you are trying to do, then more explanation and some sample data and expected result would help.

 

[ultracyclist]

That worked. Thank you for your help.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.