Maybe you can be more informative, If you would have only one sheet what
would you do?
Do you only want to count in cell B6 in all sheets how many time A exists?
If so create a list of all 10 sheets (you cannot use first:last sheet), call
the list (insertnamedefine) something, let's say MySheets then use

=SUMPRODUCT(COUNTIF(INDIRECT("'"&MySheets&"'!B6"), "A"))

will count A in B6

If you want to count how many times A, B C and D occurs


=SUMPRODUCT(COUNTIF(INDIRECT("'"&MySheets&"'!B6"), {"A","B","C","D"}))



--
Regards,

Peo Sjoblom

(No private emails please)


"Gitel" wrote in message
...
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