View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TDLambert TDLambert is offline
external usenet poster
 
Posts: 1
Default Sum Function with wrong total shown

Hi

Can anyone help. When I enter this formula
=SUM((D18:D22),+(F18:F22),+(H18:H22)) the end result is 7000. In using
Insert/Function the Function Arrguments box shows the Formula result = 15000
which correct.
Why does 7000 show?
--
TDLambert