# Sumifs with multiple criteria

#### 77winston

##### New Member
Hi,
I'm currently using the following formula to sum one criteria/condition.
I was wondering how do I add 4 more criteria/conditions to the existing formula?

=SUMIFS(Sheet3!\$E:\$E,Sheet3!\$A:\$A,"11",Sheet3!\$I:\$I,C\$3)

I want to add where Sheet3!\$A:\$A,"1" +Sheet3!\$A:\$A,"2" +Sheet3!\$A:\$A,"3" +Sheet3!\$A:\$A,"4"

could this be possible?

thanks,

Winston

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### Weazel

##### Well-known Member
if i'm understanding correctly maybe something like...

=SUM(SUMIFS(Sheet3!E2:E6,Sheet3!I2:I6,Sheet3!C3,Sheet3!A2:A6,{1,2,3,4,11}))

#### 77winston

##### New Member
if i'm understanding correctly maybe something like...

=SUM(SUMIFS(Sheet3!E2:E6,Sheet3!I2:I6,Sheet3!C3,Sheet3!A2:A6,{1,2,3,4,11}))

Thanks for that.

I'll try the formula provided.

Replies
5
Views
53
Replies
16
Views
123
Replies
0
Views
46
Replies
2
Views
75
Replies
7
Views
104