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.