ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Matching a Year and then Summing the totals (https://www.excelbanter.com/excel-programming/365199-matching-year-then-summing-totals.html)

Anice

Matching a Year and then Summing the totals
 
I am trying to create a program which will calculate the totals for a fiscal
year. I would like the program to find the first occurance of a year (Jan)
and then go back 3 cells (or months) and add together the 12 months worth of
information. It needs to be able to do this for an unknown number of years,
which are specified on a different sheet.

Any help would be great!!


All times are GMT +1. The time now is 11:05 AM.

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