I need help with a formula to calculate a absolute total from a column of totals.
I thought this was simple, but the formula I made didn't work.
I appreciate any help.
Thanks,
Nick
I need help with a formula to calculate a absolute total from a column of totals.
I thought this was simple, but the formula I made didn't work.
I appreciate any help.
Thanks,
Nick
Last edited by avidcat; 01-25-2009 at 12:45 PM.
That could mean two things.
To sum the absolute value of each cell in the column, try:
=SUM(ABS(D1:D12))
..confirmed as an array, CTRL-SHIFT-ENTER
To get the absolute value of the result after summing the individual cells with their actual value:
=ABS(SUM(D1:D12))
...confirmed with a normal ENTER.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi,
What was the formula you created?
What do you mean by an 'absolute total from a column of columns'?
Do you perhaps mean a total of all columns? In which case =SUM(A:B) should do provided A & B don't themselves also contain a Total of their respective columns. In which case =SUM(A:B)/2 would be one option, or =SUM(A10:B100) where the numbers start in Row 10 and any column totals are above this.
HTH
Thanks,
=SUM(ABS(D1:D12)) worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks