View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anice Anice is offline
external usenet poster
 
Posts: 12
Default 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!!