# Sumifs that ignores 2 items

#### kfwp

##### New Member
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)

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### peterhinton

##### Active Member
I tried your formula out, it seems to work for me ?

if the criteria in cell A1399, is found in B:B, then it will sum the corresponding Row of AR, unless that Row has 100 or 101 in the C column,

what are you getting as the result ?

#### kfwp

##### New Member
I tried your formula out, it seems to work for me ?

if the criteria in cell A1399, is found in B:B, then it will sum the corresponding Row of AR, unless that Row has 100 or 101 in the C column,

what are you getting as the result ?

Peterhinton, mine is adding up department 100 and 101 with the others

Replies
1
Views
205
Replies
3
Views
500
Replies
9
Views
1K
Replies
22
Views
719
Replies
1
Views
647

1,191,169
Messages
5,985,059
Members
439,937
Latest member
MAlhash

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back