View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default In several cells I have =?+423.55 I want total w/o the 423.55.

=sum(range of cells)-423.55*count(range of cells)

"lheck77" wrote:

I have a spreadsheet that has many cells in a column with different amounts
but all have 423.55, as an example =200.00+423.55, at the end of the column I
get a grand total. Is there a way for me to get a total that does not
include the 423.55?
Thanks Larry Heckman