Associate
- Joined
- 25 Jun 2005
- Posts
- 1,092
Any excel gurus here?
Got a sumif statement that isn't working but doesn't give an error, just zero in the output box.
=SUMIF (C2:C50,"<>yes",E2:E50 )
C2:50 is the money owed, E2:E50 is a column with yes written in if they've paid. The formula should then total it up excluding the yes entries.
But it doesn't and I'm stumped!
Got a sumif statement that isn't working but doesn't give an error, just zero in the output box.
=SUMIF (C2:C50,"<>yes",E2:E50 )
C2:50 is the money owed, E2:E50 is a column with yes written in if they've paid. The formula should then total it up excluding the yes entries.
But it doesn't and I'm stumped!