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)