COUNTIF with 3 exceptions

I

ianripping

In column A i have either the number's 1 or 2
In column B i have either the letters a or b
and in Column C i have either the letters f or g

I want the number of 1's with b's that occur when Column C has f.

If i want to add the amount of 1's with b's I use this formula : -

=COUNTIF((A1:A1000,"1")*(B1:B1000,"b"))

how do I add a third exception of if f occurs in C
 
F

Frank Kabel

Hi
I would use SUMPRODUCT:
=SUMPRODUCT((A1:A1000=1)*(B1:B1000="b")*(C1:C1000="f")

HTH
Frank
 
N

Norman Harker

Hi Ian!

Try:
=SUMPRODUCT((A1:A8=1)*(B1:B8="b")*(C1:C8="f"))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top