Re: Sum of column (with word in)

Giganews Newsgroups
Subject: Re: Sum of column (with word in)
Posted by:  Biff (biffinpi…@comcast.net)
Date: Tue, 16 May 2006

Hi!

Try this:

=J46-J47+IF(J48="Free",0,J48)

Biff

"ianonline" <ianonline.27xfdb_1147827001.5193@excelforum-nospam.com> wrote
in message news:ianonline.27xfdb_1147827001.5193@excelforum-nospam.com...
>
> 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

None

In response to

Sum of column (with word in) posted by ianonline on Tue, 16 May 2006