Simple SUMIF formula gone wrong!

[exutable]

Hey I was wondering what is wrong with this formula, I want it to sum only if the row next to it said shipped and the row next to that doesn't say PAID

Please Login or Register  to view this content.

[duane]

try this

=SUMPRODUCT((N2:N35="SHIPPED")*(O2:O35="<>PAID")*(L2:L35))

[exutable]

It gives me a negative number, I am trying to get it so that each row can be either shipped and paid and not the whole column is required to be filled with shipped or paid example:
$1.00 SHIPPED
$1.00 SHIPPED PAID
$1.00

SUM=$1.00

row one added to sum because it is shipped
row two not added because it is paid
row 3 not added because it isn't shipped

[daddylonglegs]

I think duane's suggestion has a typo, try this amendment

=SUMPRODUCT((N2:N35="SHIPPED")*(O2:O35<>"PAID")*L2:L35)

[duane]

yes, but you need another set of ()

=SUMPRODUCT((N2:N35="SHIPPED")*(O2:O35<>"PAID")*(L2 :L35))

[exutable]

Thanks works perfectly(the last one)

[daddylonglegs]

yes, but you need another set of ()

=SUMPRODUCT((N2:N35="SHIPPED")*(O2:O35<>"PAID")*(L2 :L35))

....works fine for me without the parentheses....