I am having a problem coming up with the correct formula. I need a formula
that if any row in column C says "show" then I want colum B to sum the
numbers in that row/column only. Im not sure why its not working. I have a
mix of numbers and words in column C if it makes any difference.

Try
=SUMIF(C:C,"Show",B:B)

If that doesnt work try...Check for any space before/after like ' show '
=SUMIF(C:C,"*Show*",B:B)

If this post helps click Yes
---------------
Jacob Skaria


"Misplaced Mainer" wrote:

I am having a problem coming up with the correct formula. I need a formula
that if any row in column C says "show" then I want colum B to sum the
numbers in that row/column only. Im not sure why its not working. I have a
mix of numbers and words in column C if it makes any difference.

I tried the first formula and Im not getting an error message so Im further
along than I was but it is returning 0 when it should be 73

"Jacob Skaria" wrote:

Try
=SUMIF(C:C,"Show",B:B)

If that doesnt work try...Check for any space before/after like ' show '
=SUMIF(C:C,"*Show*",B:B)

If this post helps click Yes
---------------
Jacob Skaria


"Misplaced Mainer" wrote:

I am having a problem coming up with the correct formula. I need a formula
that if any row in column C says "show" then I want colum B to sum the
numbers in that row/column only. Im not sure why its not working. I have a
mix of numbers and words in column C if it makes any difference.

Right a cell in ColB with value and Format Cells to check whether the cells
are formatted as text.. If so to convert these cells to numeric format.
Copy a blank cell..Select ColBRight clickPasteSpecialAddHit OK. now try
your formulas

If this post helps click Yes
---------------
Jacob Skaria


"Misplaced Mainer" wrote:

I tried the first formula and Im not getting an error message so Im further
along than I was but it is returning 0 when it should be 73

"Jacob Skaria" wrote:

Try
=SUMIF(C:C,"Show",B:B)

If that doesnt work try...Check for any space before/after like ' show '
=SUMIF(C:C,"*Show*",B:B)

If this post helps click Yes
---------------
Jacob Skaria


"Misplaced Mainer" wrote:

I am having a problem coming up with the correct formula. I need a formula
that if any row in column C says "show" then I want colum B to sum the
numbers in that row/column only. Im not sure why its not working. I have a
mix of numbers and words in column C if it makes any difference.

We're all waiting, with bated breath, for the results of your test using
Jacob's *second* formula!

If that fails, I would guess that you *don't* have true, XL recognized
numbers in Column B.

If that be the case, try this formula, which will total text numbers as well
as *true* numbers:

=SUMPRODUCT((ISNUMBER(SEARCH("show",C1:C1000)))*B1 :B1000)


--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Misplaced Mainer" wrote in
message ...
I tried the first formula and Im not getting an error message so Im further
along than I was but it is returning 0 when it should be 73

"Jacob Skaria" wrote:

Try
=SUMIF(C:C,"Show",B:B)

If that doesnt work try...Check for any space before/after like ' show '
=SUMIF(C:C,"*Show*",B:B)

If this post helps click Yes
---------------
Jacob Skaria


"Misplaced Mainer" wrote:

I am having a problem coming up with the correct formula. I need a
formula
that if any row in column C says "show" then I want colum B to sum the
numbers in that row/column only. Im not sure why its not working. I have
a
mix of numbers and words in column C if it makes any difference.

HA!!! One reason it wasnt working was because I actually needed D and C and
not C and D, once I changed that and put the formula outside of column D
(moved to E) It worked, thank you so much. My boss and I have sat here for
the last two hours trying to get it.

"Jacob Skaria" wrote:

Right a cell in ColB with value and Format Cells to check whether the cells
are formatted as text.. If so to convert these cells to numeric format.
Copy a blank cell..Select ColBRight clickPasteSpecialAddHit OK. now try
your formulas

If this post helps click Yes
---------------
Jacob Skaria


"Misplaced Mainer" wrote:

I tried the first formula and Im not getting an error message so Im further
along than I was but it is returning 0 when it should be 73

"Jacob Skaria" wrote:

Try
=SUMIF(C:C,"Show",B:B)

If that doesnt work try...Check for any space before/after like ' show '
=SUMIF(C:C,"*Show*",B:B)

If this post helps click Yes
---------------
Jacob Skaria


"Misplaced Mainer" wrote:

I am having a problem coming up with the correct formula. I need a formula
that if any row in column C says "show" then I want colum B to sum the
numbers in that row/column only. Im not sure why its not working. I have a
mix of numbers and words in column C if it makes any difference.