Simple SUMIF formula gone wrong!
 

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:
--------------------
::=SUMIF(AND(N2:N35=\"SHIPPED\", O2:O35=\"<PAID\"),L2:L35)::
--------------------


--
exutable
------------------------------------------------------------------------
exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=539712

Simple SUMIF formula gone wrong!
 

try this

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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=539712

Simple SUMIF formula gone wrong!
 

It gives me a negative number


--
exutable
------------------------------------------------------------------------
exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=539712

Simple SUMIF formula gone wrong!
 

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

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=539712

Simple SUMIF formula gone wrong!
 

yes, but you need another set of ()

=SUMPRODUCT((N2:N35="SHIPPED")*(O2:O35<"PAID")*(L 2 :L35))


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=539712

Simple SUMIF formula gone wrong!
 

Thanks works perfectly(the last one)


--
exutable
------------------------------------------------------------------------
exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=539712

Simple SUMIF formula gone wrong!
 

duane Wrote:
yes, but you need another set of ()

=SUMPRODUCT((N2:N35="SHIPPED")*(O2:O35<"PAID")*(L 2 :L35))

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=539712