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

Sam Arabian

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)

Aya

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

Aya

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

Sam Arabian

That works thank you Aya!

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

Aya

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