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

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

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

=COUNTIF(A:A,B1)

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Juran" wrote in message
...
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

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

Oops, 2 different criteria

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Peo Sjoblom" wrote in message
...
=COUNTIF(A:A,B1)

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Juran" wrote in message
...
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

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

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.

"Peo Sjoblom" wrote:

Oops, 2 different criteria

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Peo Sjoblom" wrote in message
...
=COUNTIF(A:A,B1)

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Juran" wrote in message
...
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

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

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards,

Peo Sjoblom

Portland, Oregon




"Juran" wrote in message
...
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.

"Peo Sjoblom" wrote:

Oops, 2 different criteria

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Peo Sjoblom" wrote in message
...
=COUNTIF(A:A,B1)

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Juran" wrote in message
...
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

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

"Peo Sjoblom" wrote:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards,

Peo Sjoblom

Portland, Oregon




"Juran" wrote in message
...
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.

"Peo Sjoblom" wrote:

Oops, 2 different criteria

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Peo Sjoblom" wrote in message
...
=COUNTIF(A:A,B1)

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Juran" wrote in message
...
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




Peo,

Thank you.

Juran