I have a workbook with 10 sheets with columns of text and a summary sheet. I
want to count how many times A, B, C, D appear on each of the sheets for each
number.
I've tried
=SUMPRODUCT(COUNTIF(INDIRECT("''Armitage:Viayra&'! B6"),A))
=SUMPRODUCT(COUNT(IF(Armitage:Viayra!$B$6,"D"),"A" ))
The first returns a #REF error and the second returns 0