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) |
Could you please attach a sample file for sumifs function too to practise. thank youSame 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