Using AND and SUMIF function together

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello,

I have 2 columns of invoices totals like below:

Column I Column O
Original Invoice Total Amount Shortpaid
$45,679.00 ($-255.00)
$123.00 $0.00
$1,500.00 blank
blank blank

I'm trying to sum column O to give a total of what the client still owes us.
I need to:

a) Sum column O if the amounts in column O are < 0 (which means the client
has shortpd the original invoice) AND
b) Sum column I (the amount of the original invoice) if the invoice has flat
out not been paid--so sum column I if column O is blank (not been pd) AND
column I has a number in it (if the invoice exists and there's no blank
space in column I)

I tried this but I get a "FALSE" in my cell:

=AND(SUMIF(O3:O265,"<0"),SUMIF(I3:I266,AND(ISNUMBER(I3:I266), O3:O266="")))

Can someone help with this function (no macros please)?

Thanks very much!
.

Quantcast