Hello
I need help with my formula. The result is only counting Part type(Electrical)- $B$2 and ignoring the rest of the part type.
I need help with my formula. The result is only counting Part type(Electrical)- $B$2 and ignoring the rest of the part type.
Supplier name | Part Type | Payment status | Parts name | |
Red | Electrical | paid | A | SUMPRODUCT(COUNTIFS('Data '!$E:$E,$A$2:$A$3,'Data '!$I:$I,$B$2:$B$4,'Data '!$J:$J,$C$2,'Data '!$N:$N,$D5)) |
Green | Plumbing | A | ||
Tiling | A | |||
A | ||||
A | ||||
A | ||||
A |