Count if cetain text is in another column, same row.
 

Excel 2003,

Simple, I hope. Column A has "X"s here and there (like checkmarks).
Some are blank. Column B has either "Bob" or "John". I want a cell to
total the number of X's for Bob, and another cell to total the X's for
John.
-Brad

Count if cetain text is in another column, same row.
 

Try this:

=SUMPRODUCT((A1:A100="X")*(B1:B100="Bob"))

=SUMPRODUCT((A1:A100="X")*(B1:B100="John"))

Adjust the ranges to suit your data.

Hope this helps.

Pete

On Mar 28, 6:36*pm, bhammer wrote:
Excel 2003,

Simple, I hope. Column A has "X"s here and there (like checkmarks).
Some are blank. Column B has either "Bob" or "John". I want a cell to
total the number of X's for Bob, and another cell to total the X's for
John.
-Brad

Count if cetain text is in another column, same row.
 

On Fri, 28 Mar 2008 11:36:41 -0700 (PDT), bhammer
wrote:

Excel 2003,

Simple, I hope. Column A has "X"s here and there (like checkmarks).
Some are blank. Column B has either "Bob" or "John". I want a cell to
total the number of X's for Bob, and another cell to total the X's for
John.
-Brad

Try this:

=SUMPRODUCT((A:A="X")*(B:B="John"))

Hope this helps / Lars-Åke

Count if cetain text is in another column, same row.
 

Here is a formula for John...

=SUMPRODUCT((A1:A100="X")*(B1:B100="John"))

and for Bob...

=SUMPRODUCT((A1:A100="X")*(B1:B100="Bob"))

Rick


"bhammer" wrote in message
...
Excel 2003,

Simple, I hope. Column A has "X"s here and there (like checkmarks).
Some are blank. Column B has either "Bob" or "John". I want a cell to
total the number of X's for Bob, and another cell to total the X's for
John.
-Brad

Count if cetain text is in another column, same row.
 

For Bob:
=SUMPRODUCT(--(A2:A100="X"),--(B2:B100="Bob"))

For John
=SUMPRODUCT(--(A2:A100="X"),--(B2:B100="John"))

HTH,
Paul

--

"bhammer" wrote in message
...
Excel 2003,

Simple, I hope. Column A has "X"s here and there (like checkmarks).
Some are blank. Column B has either "Bob" or "John". I want a cell to
total the number of X's for Bob, and another cell to total the X's for
John.
-Brad

Count if cetain text is in another column, same row.
 

Lars,

you can only use full-column references in XL2007 - the OP stated
XL2003.

Pete

On Mar 28, 6:41*pm, Lars-Åke Aspelin
wrote:
On Fri, 28 Mar 2008 11:36:41 -0700 (PDT), bhammer

wrote:
Excel 2003,

Simple, I hope. Column A has "X"s here and there (like checkmarks).
Some are blank. Column B has either "Bob" or "John". I want a cell to
total the number of X's for Bob, and another cell to total the X's for
John.
-Brad

Try this:

=SUMPRODUCT((A:A="X")*(B:B="John"))

Hope this helps / Lars-Åke

Count if cetain text is in another column, same row.
 

On Fri, 28 Mar 2008 11:47:31 -0700 (PDT), Pete_UK
wrote:

Lars,

you can only use full-column references in XL2007 - the OP stated
XL2003.

Pete

OK, thanks for telling.

Lars-Åke