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

Code:

 

[duane]

try this

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

 

[exutable]

It gives me a negative number

 

[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....