LinkBack URL
About LinkBacks
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
=SUMIF(AND(N2:N35="SHIPPED", O2:O35="<>PAID"),L2:L35)
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
=SUMIF(AND(N2:N35="SHIPPED", O2:O35="<>PAID"),L2:L35)
try this
=SUMPRODUCT((N2:N35="SHIPPED")*(O2:O35="<>PAID")*(L2:L35))
not a professional, just trying to assist.....
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
Last edited by exutable; 05-07-2006 at 08:28 PM.
I think duane's suggestion has a typo, try this amendment
=SUMPRODUCT((N2:N35="SHIPPED")*(O2:O35<>"PAID")*L2:L35)
yes, but you need another set of ()
=SUMPRODUCT((N2:N35="SHIPPED")*(O2:O35<>"PAID")*(L2 :L35))
Thanks works perfectly(the last one)
....works fine for me without the parentheses....Originally Posted by duane
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks