COUNTIF with 3 exceptions

  • Thread starter Thread starter ianripping
  • Start date Start date
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
 
Hi
I would use SUMPRODUCT:
=SUMPRODUCT((A1:A1000=1)*(B1:B1000="b")*(C1:C1000="f")

HTH
Frank
 
Hi Ian!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top