Countifs always returns Value error

[kdawg-x]

the countifs formula returns a value error.

how to determine number of occurrences of one item meeting two criteria

[etaf]

try
=SUMPRODUCT((A3:A15="-75C")*(D3:G15="xyz"))
OR
=SUM(IF((D3:G15="MSCF")*(A3:A15="-75C"),1,0))

[kdawg-x]

Awesome! thank you. that worked.

in the sum formula, what is the purpose of the '1' and '0' at the end of the formula.?

[etaf]

is using IF , so if true creates a 1 if not creates a zero
then the SUM adds all the array results up to get the number

[kdawg-x]

thank you. I appreciate it.

[etaf]

you are welcome