something like to sum a above 0
=sumproduct((a2:a220)*(b2:b22="a")*(a2:a22))
to just count
=sumproduct((a2:a220)*(b2:b22="a"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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