Thread
:
Need help making a spreadsheet for my business.
View Single Post
#
24
Posted to microsoft.public.excel.newusers
Don Guillett
Posts: n/a
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
Reply With Quote