countif for 2003
 

I am trying to write a countif formula using two criteria in seperate cells.
I realize excel 2007 has countifs formula that will allow you to use multiple
ranges and criteria for this but is there a way to do the same thing using
excel 2003?

countif for 2003
 

Try this:

=SUMPRODUCT(--(A1:A10="x"),--(B1:B10="y"))

Using cells to hold the criteria:

D1 = x
E1 = y

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))

--
Biff
Microsoft Excel MVP


"mbreter" wrote in message
...
I am trying to write a countif formula using two criteria in seperate
cells.
I realize excel 2007 has countifs formula that will allow you to use
multiple
ranges and criteria for this but is there a way to do the same thing using
excel 2003?