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.