Software

Ask something
Discussion Locked

Formula

0 helpful
3 replies

by ljackson.desoto

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a way to specify a formula to do something if the critera DOES NOT equal something. For example: I am doing a SUMIF formula and I want it to say: = SUMIF(range does not equal) as opposed to SUMIF(range=). I know this is not the complete formula, I just need to know if the NOT EQUALS can be valid.
Thanks

3 replies

by ljackson.desoto

Thanks for the quick response. I didn't use the range as you had in your answer, but I went to the office link and used another function.

This discussion is closed to new replies.