On Jan 7, 2:05*pm, "Ron Coderre"
wrote:
Try something like this:

=SUMPRODUCT(ISNUMBER(A1:A10)*(A1:A100)*(B1:B10="A "))

I originally tried
=SUMPRODUCT((A1:A100)*(B1:B10="A"))

BUT....
if Col_A contains text (even an apostrophe)
with a corresponding "A" in Col_B

Example:
A5: Ron
B5: A

...That pair is counted.

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"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- Hide quoted text -

- Show quoted text -

Thanks all for your help.