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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=COUNTIF(A:A,B1)

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

--
Regards,

Peo Sjoblom

Portland, Oregon
 
Oops, 2 different criteria

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

--
Regards,

Peo Sjoblom

Portland, Oregon
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM IF sum of two collumns 2
Filling in cells (or not) based on the entry in a specific collumn 3
Collumns and rows 2
Counting sets of cells based on two parameters 4
Counting rows based on the contents of multiple cells 2
Please help with "concatenate". 2
Range that expand 1
Making a CSV from several collumns in excell 3

Back
Top