-Disregard my last question... this worked!!!

Thank you very much!

-D

"B. R.Ramachandran" wrote:

Hi,

If you want to count the number of rows where column A is greater than 0 but
column B is not greater than 0 (i.e., less than or equal to 0), use the
following formula. Change the data ranges in the formula (i.e., A1:A100 and
B1:B100) to suit to your data.

=SUMPRODUCT((A1:A1000)*(B1:B100<=0))

If this helps, please click "Yes".

Regards,
B. R. Ramachandran


"Donna@Dell" wrote:

Hello -

I need a formula that will count the number of lines that are greater than 0
in one column but also need to subtract the number of lines that are greater
than 0 in another column.

There are 16 lines that are greater than 0, within that subset there is 1
line item that is greater than 0 in the other column. I've tried sum(if....,
sumproduct, countif doesn't work.

HELP!

Donna