Use a formula like the following:

=SUMPRODUCT((A1:A50)*(B1:B5="A"))

Change the A1:A5 and B1:B5 references to the appropriate ranges.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Thyag" wrote in message
...
Hi,

I Need a formula to count all the positive values with an addtioonal
condition.

Example -
Column A Column B
100 A
200- A
300 A
400 B

In The above case i need the formula to get me the count all the
positive figures with a "A" in column B.


Thanks,
Thyag