COUNTIF

[Lacy]

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

 

[Peo Sjoblom]

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

could look like

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

meaning range1=criteria1ANDrange2=criteria2ANDrange3=criteria3

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

 

[Don Guillett]

try
=sumproduct((a2:a200="a")*(b2:b200=1)*(c2:c200>23))

 

[Lacy]

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

Thanks again,
Lacy