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
 10.7K Get Help
 64 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!