software

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

quot;Juranquot; gt; wrote in message
...
gt;I have a spreadsheet which I would like to count the number of a word in
gt;one
gt; collumn, but only if which matches with a word in a different collumn.
gt;
gt; Thank
gt;
gt; JuranOops, 2 different criteria

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

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; =COUNTIF(A:A,B1)
gt;
gt; is that what you mean, if not post back with an explanation
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Juranquot; gt; wrote in message
gt; ...
gt;gt;I have a spreadsheet which I would like to count the number of a word in
gt;gt;one
gt;gt; collumn, but only if which matches with a word in a different collumn.
gt;gt;
gt;gt; Thank
gt;gt;
gt;gt; Juran
gt;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.

quot;Peo Sjoblomquot; wrote:

gt; Oops, 2 different criteria
gt;
gt; =SUMPRODUCT(--(Range1=criteria1),--(Range2=criteria2))
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; ...
gt; gt; =COUNTIF(A:A,B1)
gt; gt;
gt; gt; is that what you mean, if not post back with an explanation
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; Portland, Oregon
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Juranquot; gt; wrote in message
gt; gt; ...
gt; gt;gt;I have a spreadsheet which I would like to count the number of a word in
gt; gt;gt;one
gt; gt;gt; collumn, but only if which matches with a word in a different collumn.
gt; gt;gt;
gt; gt;gt; Thank
gt; gt;gt;
gt; gt;gt; Juran
gt; gt;
gt;
gt;

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

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Juranquot; gt; wrote in message
...
gt; Peo,
gt;
gt; Thank you. Did work exactly they way I expected.
gt;
gt; If you do mind I asking (I would like to understand your answer) why the
gt; dashes and why sumproduct instead of countif?
gt;
gt; Once again thank you.
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Oops, 2 different criteria
gt;gt;
gt;gt; =SUMPRODUCT(--(Range1=criteria1),--(Range2=criteria2))
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Peo Sjoblomquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; =COUNTIF(A:A,B1)
gt;gt; gt;
gt;gt; gt; is that what you mean, if not post back with an explanation
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Regards,
gt;gt; gt;
gt;gt; gt; Peo Sjoblom
gt;gt; gt;
gt;gt; gt; Portland, Oregon
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Juranquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt;I have a spreadsheet which I would like to count the number of a word
gt;gt; gt;gt;in
gt;gt; gt;gt;one
gt;gt; gt;gt; collumn, but only if which matches with a word in a different collumn.
gt;gt; gt;gt;
gt;gt; gt;gt; Thank
gt;gt; gt;gt;
gt;gt; gt;gt; Juran
gt;gt; gt;
gt;gt;
gt;gt;

quot;Peo Sjoblomquot; wrote:

gt; www.xldynamic.com/source/xld.SUMPRODUCT.html
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Juranquot; gt; wrote in message
gt; ...
gt; gt; Peo,
gt; gt;
gt; gt; Thank you. Did work exactly they way I expected.
gt; gt;
gt; gt; If you do mind I asking (I would like to understand your answer) why the
gt; gt; dashes and why sumproduct instead of countif?
gt; gt;
gt; gt; Once again thank you.
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; Oops, 2 different criteria
gt; gt;gt;
gt; gt;gt; =SUMPRODUCT(--(Range1=criteria1),--(Range2=criteria2))
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; Portland, Oregon
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; =COUNTIF(A:A,B1)
gt; gt;gt; gt;
gt; gt;gt; gt; is that what you mean, if not post back with an explanation
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt; Regards,
gt; gt;gt; gt;
gt; gt;gt; gt; Peo Sjoblom
gt; gt;gt; gt;
gt; gt;gt; gt; Portland, Oregon
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Juranquot; gt; wrote in message
gt; gt;gt; gt; ...
gt; gt;gt; gt;gt;I have a spreadsheet which I would like to count the number of a word
gt; gt;gt; gt;gt;in
gt; gt;gt; gt;gt;one
gt; gt;gt; gt;gt; collumn, but only if which matches with a word in a different collumn.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Thank
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Juran
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt; Peo,

Thank you.

Juran