Hi
try the following (as COUNTIF only accepts one condition):
=SUMPRODUCT((H1:H1000="foo")*(J1:J1000="bar"))
Note: SUMPRODUCT does not accept range references like H:H - therefore
I used H1:H1000

--
Regards
Frank Kabel
Frankfurt, Germany

I want to count entries in a column that equal a value only if a
value
in another column in the same row equals another value.

I can use COUNTIF(H:H,"foo") to count all cells with "foo" in coulmn
H.

How do do it if I only want to count "foo" if column J equals "bar"?


---
Message posted from http://www.ExcelForum.com/