View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dinesh
 
Posts: n/a
Default Absolute function

Hi,

I am looking for a formula which can convert formula into absolute number
not as a Total answer but adding the each number seperately.

Example
Col A
10
25
30

Formula is =a1+a2+a3..So the answer would be 45. But I like to see the
answer as=10+25+30 or conver the formula into abolute number by addition of
each number rather than total.

Is there a way to conver this?

Thanks for the help.

Dinesh