Re: Sum of column (with word in)

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


Try this:



"ianonline" <> wrote
in message
> 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:
> View this thread:



In response to

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