COUNTIF

  • Thread starter Thread starter Lacy
  • Start date Start date
L

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
 
=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
 
Thanks guys. I didn't see this a minute ago and posted
the question again. Just ignore it.

Thanks again,
Lacy
 
Back
Top