View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett
 
Posts: n/a
Default Need help making a spreadsheet for my business.

glad to help

--
Don Guillett
SalesAid Software

"ElNino" wrote in
message ...

Don Guillett Wrote:
a cursory look suggests a bit shorter
countif(l2:w2,"available")*99

--
Don Guillett
SalesAid Software


Hey, thanks Don... it worked! I even figured out why it wouldn't add up
correctly if I placed *IF(K2="discontinuing",0,1) at the end of this
formula (I had to seperate the equations). So, this is my new formula
to add up the quantitty:

Code:
--------------------
=(SUM(L2:W2)+COUNTIF(L2:W2,"Available")*99)*IF(K2= "discontinuing",0,1)
--------------------


:)


--
ElNino
------------------------------------------------------------------------
ElNino's Profile:
http://www.excelforum.com/member.php...o&userid=25725
View this thread: http://www.excelforum.com/showthread...hreadid=391062