Does not equal "<>" does not return when looking at a number
I want to sum the Range "Students" IF the cell does not equal "/". The formula does not work when the criterion cell is equal to any number.
Can anyone help work around this
Current Formula:
=SUMIF([21_03]34:[21_03]42, <>"/", $Notes34:$Notes42)
Best Answer

Hi Sam—You could try this:
=SUM($Notes34:$Notes42)  SUMIF([21_03]34:[21_03]42, "/", $Notes34:$Notes42)
It may not be the simplest/most efficient way, but gets the job done.
Aya
Answers

Hi Sam—You could try this:
=SUM($Notes34:$Notes42)  SUMIF([21_03]34:[21_03]42, "/", $Notes34:$Notes42)
It may not be the simplest/most efficient way, but gets the job done.
Aya

That works thank you Aya!
Still confused why SS does not pickup numbers when the "<>/" is the criterion.

I'm guessing the criterion for the function is 'textbased', thus having the result as 0 when the range only has numbers and blank cells.
You can try adding apostrophes to the numbers and blank cells and see your original formula would begin to work.
Again, this is just my speculation.
Aya
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!