COUNTIF

Im trying to use COUNTIF, but I have three criteria in
three different columns. Does anyone know of a way to
accomplish this?

Thanks
Lacy

=SUMPRODUCT(--(Range1=criteria1),--(Range2=criteria2),--(Range3=criteria3))

could look like

=SUMPRODUCT(--(A1:A10=1),--(B1:B10=2),--(C1:C10=3))

meaning range1=criteria1ANDrange2=criteria2ANDrange3=crite ria3

if it is OR instead


=SUMPRODUCT((A1:A10=1)+(B1:B10=2)+(C1:C10=3))

or even

=SUMPRODUCT((A1:A10={1,2,3})+(B1:B10={1,2,3})+(C1: C10={1,2,3}))


--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


"Lacy" wrote in message
...
Im trying to use COUNTIF, but I have three criteria in
three different columns. Does anyone know of a way to
accomplish this?

Thanks
Lacy

try
=sumproduct((a2:a200="a")*(b2:b200=1)*(c2:c20023) )

--
Don Guillett
SalesAid Software

"Lacy" wrote in message
...
Im trying to use COUNTIF, but I have three criteria in
three different columns. Does anyone know of a way to
accomplish this?

Thanks
Lacy

Thanks guys. I didn't see this a minute ago and posted
the question again. Just ignore it.

Thanks again,
Lacy