How do I use COUNTIF with two different criteria (2 collumns)

J

Juran

I have a spreadsheet which I would like to count the number of a word in one
collumn, but only if which matches with a word in a different collumn.

Thank

Juran
 
P

Peo Sjoblom

=COUNTIF(A:A,B1)

is that what you mean, if not post back with an explanation

--
Regards,

Peo Sjoblom

Portland, Oregon
 
P

Peo Sjoblom

Oops, 2 different criteria

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

--
Regards,

Peo Sjoblom

Portland, Oregon
 
J

Juran

Peo,

Thank you. Did work exactly they way I expected.

If you do mind I asking (I would like to understand your answer) why the
dashes and why sumproduct instead of countif?

Once again thank you.
 
Top