subtotal %

  • Thread starter Thread starter gatarossi
  • Start date Start date
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é.
 
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

(e-mail address removed)
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é.
 
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
 
Back
Top