How do I COUNTIF in excel using multiple criteria?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a function which looks to see if multiple criteria,
across different columns are met.

Idealy I should think the following function should work, but alas, it does
not:

=COUNTIF(AND(A1:A5=1, B1:B5=2))

Any suggestions?
 
=SUMPRODUCT((A1:A5=1)*(B1:B5=2)*(C1:C5=3)) etc

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Back
Top