Need help on COUNTIFS

[rskfriends]

Hello Friends,

How to count entire "Test" value in the cells A:F

A	B	C	D	E	F
10	5	0	3	5	5
Test	Test,ok	test	Test,cancel	Test,modi	Test

Formula used in G column =COUNTIFS(A1:F1,">0",A2:F2,IF(MATCH("Test*",A2:F2)>0,"Test","")). Result shown as 2 only. i need result as 5.
Please anyone can help me.

[gak67]

Try this:

Please Login or Register  to view this content.

Your formula was checking to see if any of row 2 started with "Test" but then only matched those that contained only "Test" so it was ignoring B2, D2 and E2.

[rskfriends]

Thank gak67