Problem of calculation COUNT in Crystal Report

The problem is:

There is a table in SQl and has 3 columns eg Col 1, Col2, Col3.
& they have following entries.

Col1 Col2 Col3
11 12 A
33 32 B
10 10 B
40 50 A
Now i want the count of the tabel where Col3 is B.
The result should return me 2
It should be displayed under one heading.

Also i want the count of the tabel where Col3 is A
The result should return me 2
It should be displayed under another heading.

I have done it using a command and Stored Procedure.
But i dont want to do with them.

I want a formula to be used in crystal report (Formula editor/ SQL Expression)

Please, if any1 can help me outhai,
Use Running Total fields, give the conditions in the Running Total Field Formulas. hope this will works you better. let me know the status.

regards,
Bhuvana