# Does not equal "<>" does not return when looking at a number

Options

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)

• ✭✭✭
Options

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

• ✭✭✭
Options

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

• Options

That works thank you Aya!

Still confused why SS does not pickup numbers when the "<>/" is the criterion.

• ✭✭✭
Options

I'm guessing the criterion for the function is 'text-based', 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!