subtotal %

G

gatarossi

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é.
 
S

Sandy Mann

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


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
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é.
 
M

Mark Lincoln

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
 
Top