Dear all,
I'm trying to put subtotal in my list, but I'm having this problem
code year_1 year_2 variation%
100 100 110 10,0%
100 115 130 13,4%
100 total 215 240 23,4%
total geral 215 240 23,4%
And I need this result:
code year_1 year_2 variation%
100 100 110 10,0%
100 115 130 13,4%
100 total 215 240 11,6%
total geral 215 240 11,6%
How can I solve this?
Thanks a lot!!!
André.
Sandy Mann - 12 Sep 2007 16:52 GMT
What is it that you want to solve? Column totals?
Code 100 for Year_1:
=SUMIF(A2:A6,100,B2:B6)
Code 101 for Year_1
=SUMIF(A2:A6,101,B2:B6)
% Totals?
With column totals in Row 7:
=C7/B7-1

Signature
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk
Dear all,
I'm trying to put subtotal in my list, but I'm having this problem
code year_1 year_2 variation%
100 100 110 10,0%
100 115 130 13,4%
100 total 215 240 23,4%
total geral 215 240 23,4%
And I need this result:
code year_1 year_2 variation%
100 100 110 10,0%
100 115 130 13,4%
100 total 215 240 11,6%
total geral 215 240 11,6%
How can I solve this?
Thanks a lot!!!
André.
Mark Lincoln - 12 Sep 2007 17:11 GMT
In your third row, you're adding the percentages of your first two
rows. You need to use the same calculation for the figures in the
third row as you do for each of the first two rows.
Mark Lincoln
On Sep 12, 9:54 am, gataro...@ig.com.br wrote:
> Dear all,
>
[quoted text clipped - 19 lines]
>
> André.