"Bob Phillips" skrev i en meddelelse
...

"Leo Heuser" wrote in message
...


and for counting the numbers of 8a AND 8b

=SUMPRODUCT(COUNTIF(D4:D9,{"8a,"8b"}"))

Typos apart, why introduce a nested function call?

Good question! I guess, I was caught by the subject line.

How on earth did that quotation mark land after "}" instead of after "a" :-)