Thread: Simple SUMIF formula gone wrong!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
exutable
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote