I need a sumif statement that adds up values in column ar if the number in column b equals the right account code (found in a) but only if the department (in c) is NOT 100 or 101
My attempt doesn't ignore the department correctly; it adds up all departments
=sumifs(ar:ar,B:B,A1399,C:C,"<>"&100,c:c,"<>"&101)
My attempt doesn't ignore the department correctly; it adds up all departments
=sumifs(ar:ar,B:B,A1399,C:C,"<>"&100,c:c,"<>"&101)