Sum of column (with word in)

Giganews Newsgroups
Subject: Sum of column (with word in)
Posted by:  ianonline (ianonline.27xfdb_1147827001.5193@excelforum-nospam.com)
Date: Tue, 16 May 2006

Can anyone help with what I guess is simple but I'm stuck with!

I'm producing an invoice template. The postage is (thanks to brilliant
help provided to someone else on ExcelTip) now calculated automatically
and when the subtotal is over a certain value, then the postage cell
displays the word "FREE".

I am summing up J46 (subtotal) minus J47 (discount) + J48 (postage)

Now, Excel can't normally add up a column of numbers that includes a
word, but I expect there is a way around it. Do you know what it is?

Thank you for your help.

Ian

--
ianonline
------------------------------------------------------------------------
ianonline's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34279
View this thread:http://www.excelforum.com/showthread.php?threadid=542736

Replies