We help IT Professionals succeed at work.

Using sumif for not equal to - Excel

morinia
morinia asked
on
Medium Priority
356 Views
Last Modified: 2012-03-15
Is there a way to use sumif to see if something is not equal

ie

sumifs (prods, yr,2011, code, ?????????)

I would like to check if code is not equal "32", "35","36"

Is there a way to do this?
Comment
Watch Question

Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
<> "32", <> "35", <> "36"
CERTIFIED EXPERT

Commented:
See if this works. Not checked

=sumproduct(prods*( yr=2011)*( (code <>32)+(code <>35)+(code <>36)))
Most Valuable Expert 2012
Top Expert 2012
Commented:
=SumIfs (prods, yr,2011, code, "<>32", code, "<>35", code, "<>36")

Dave

Explore More ContentExplore courses, solutions, and other research materials related to this topic.