Here's another one...
Data Range
A B C D E F G H I J 1 2 3 8 X X XX XXX XX X X 4 ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
This formula entered in A3:
=SUM(COUNTIF(D3:J3,{"x","xx"})*{1,2})
Bookmarks