Re: Sum of column (with word in)

Giganews Newsgroups
Subject: Re: Sum of column (with word in)
Posted by:  Dave Peterson (peters…@verizonXSPAM.net)
Date: Tue, 16 May 2006

A couple more:

=SUM(J46,-J47,J48)

=j46-j47+N(j48)

ianonline wrote:
>
> 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

--

Dave Peterson

Replies

In response to

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