Countif based on the title in my first row.

(I've attached an example spreadsheet)

Hi all,
Here is an example of how my sheet1 currently looks:

1.png

I want to create another sheet (sheet2) which counts the number of 'WB', 'WT' & 'WA'. (Regardless of the '+' and '-' symbols) based on the title rows of sheet1.

2.png

I hope this made sense found it quite difficult to articulate.

Thanks

Hi,

in B3 to be copied across

=SUMPRODUCT(--(ISNUMBER(SEARCH(LEFT(B$2,2),INDEX(Sheet1!$A$2:$F$8,,MATCH(LEFT($A3,5),Sheet1!$A$1:$F$1,0))))))

Regards

Hi again,

in B3 copied across

=COUNTIF(INDEX(Sheet1!$A$2:$F$8,,MATCH(LEFT($A3,5),Sheet1!$A$1:$F$1,0)),"*"&LEFT(B$2,2)&"*")

should do the trick