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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks