# Sum formula with different criterias

#### uday

##### Member
Hi team,

I need total sum of WD1 for BSC ,cleaning and pest in B2,B3,B4 cells. Same way this could also applied for WD2 and WD3 cells.
The data tab is Sheet2. File is attached.

Regards,
Uday

#### Attachments

• 11.1 KB Views: 9

#### AlanSidman

##### Active Member
 v E F G H 1 WD1 WD2 WD3 2 BSC 65655 91295 57992 3 Cleaning 51361 44346 42287 4 Pest 20691 13742 13867

 v E F G H 1 WD1 WD2 WD3 2 BSC =SUMIF(\$A\$2:\$A\$29,E2,\$B\$2:\$B\$29) =SUMIF(A\$2:A\$29,E2,C\$2:C\$29) =SUMIF(A\$2:A\$29,E2,D\$2:D\$29) 3 Cleaning =SUMIF(\$A\$2:\$A\$29,E3,\$B\$2:\$B\$29) =SUMIF(A\$2:A\$29,E3,C\$2:C\$29) =SUMIF(A\$2:A\$29,E3,D\$2:D\$29) 4 Pest =SUMIF(\$A\$2:\$A\$29,E4,\$B\$2:\$B\$29) =SUMIF(A\$2:A\$29,E4,C\$2:C\$29) =SUMIF(A\$2:A\$29,E4,D\$2:D\$29)

#### Peter Bartholomew

##### Well-Known Member
Same formula, slightly different appearance
= SUMIFS( Table1[WD1], Table1[items], distinctItems )
I normally set out to create the entire table as one spilt array but in this instance it was only possible to do it column by column.
The row headers 'distinctItems' were calculated using the modern array formula
= UNIQUE(Table1[items])
It is good to have new toys to play with!

##### New Member
Same formula, slightly different appearance
= SUMIFS( Table1[WD1], Table1[items], distinctItems )
I normally set out to create the entire table as one spilt array but in this instance it was only possible to do it column by column.
The row headers 'distinctItems' were calculated using the modern array formula
= UNIQUE(Table1[items])
It is good to have new toys to play with!

View attachment 62605
Could you please attach a sample file for sumifs function too to practise. thank you

#### uday

##### Member
I have attached the file can you please apply in attached file?

#### Attachments

• 12.3 KB Views: 2

here you are

#### Attachments

• 11.8 KB Views: 5