COUNTIFS multiple items in the criteria.

[fayo2009]

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.

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

 

[SanjayGMusafir]

Share an XL2BB mini sheet to understand the scenario. They way you have shared, can't judge the column and rows

 

[Fluff]

How about

=SUM(COUNTIFS('Data '!$E:$E,$A$2:$A$3,'Data '!$I:$I,TOROW($B$2:$B$4),'Data '!$J:$J,$C$2,'Data '!$N:$N,$D5))

 

[fayo2009]

How about

=SUM(COUNTIFS('Data '!$E:$E,$A$2:$A$3,'Data '!$I:$I,TOROW($B$2:$B$4),'Data '!$J:$J,$C$2,'Data '!$N:$N,$D5))

Many thanks, it worked.

 

[Fluff]

You're welcome & thanks for the feedback.