One more time asking for your help.

Perhaps, I have a silly request.

I need to count A and B in a range. Enclose my Sheet.

I know that I can do it filling my range with all A's or B's I'd need, then I'd use COUNTIF. I could hide similar values with Conditional Formatting and that would do the trick.

But, I'd really appreciate someone help me to do it with my example format.

Is this possible ?.

Thank you so much for your assistance.

Arnolf.

Book2.xls | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||

1 | ||||||||||||||||

2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | COUNT of A | COUNT of B | ||||

3 | A | 10 | ||||||||||||||

4 | B | 8 | ||||||||||||||

5 | A | B | 4 | 3 | ||||||||||||

6 | ||||||||||||||||

7 | A | B | 1 | 9 | ||||||||||||

8 | A | B | 4 | 1 | ||||||||||||

9 | ||||||||||||||||

Sheet1 |