Conditional Formula with Words and different columns

  • Thread starter Thread starter Misplaced Mainer
  • Start date Start date
M

Misplaced Mainer

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
 
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
 
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 ColB>Right click>PasteSpecial>Add>Hit OK. now try
your formulas

If this post helps click Yes
 
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)
 
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.
 
Back
Top