ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help to create calculation with code (https://www.excelbanter.com/excel-programming/408923-help-create-calculation-code.html)

Les Stout[_2_]

Help to create calculation with code
 
Hello all, i have a spreadsheet that has columns 2008 to 2012. under
each heading is a total and then 2 lines below that i have a value for
each month, Jan to Feb, as indicated below. I use a calculation in
another cell
=SUM(O74:O82,Q69:U69)Which would be from the value 4,500 in 2008 to the
bottom (Dec) and then the totals for 2009 to 2012. I would like to
create this with code. The starting point would be taken from another
sheet giving me the start year and month, which would tell me which
column(year) and which line(Month) and then the totals for the other
years. Any help would be very much appreciated.

2008 2009 2010 2011 2012
51,930 55,920 51,700 51,480 1000
16% 18% 16% 16% 0%
4,106 4,026 3,722 3,707 72
4,671 5,033 4,653 4,633 90
4,443 5,312 4,912 4,891 95
4,500 4,306 3,981 3,964 77
4,540 5,536 5,118 5,097 99
4,710 5,312 4,912 4,891 95
5,325 5,592 5,170 5,148 100
2,115 3,411 3,154 3,140 61
2,480 3,467 3,205 3,192 62
6,500 5,816 5,377 5,354 104
5,400 5,592 5,170 5,148 100
3,140 2,516 2,327 2,317 45

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com