Eric58132
08-03-2010, 10:43 AM
Hi All,
I'm having some trouble with this one, a "higher up" has asked me to make what is already an automated file (created by me) include Fiscal Year totals. What I'm having an issue with is that whenever a new month of data comes in, my "April"(beginning of our fiscal year) column moves to a different column, thus I can't hard code any sort of sums or averages. I need a formula that scans the range of Month titles for April, and then sums up each row in the data set from april on. I've enclosed an example of what I mean. I REALLY hope someone can help me out with this!
Thank you in advance, and I'll be here if there are any questions.
I'm having some trouble with this one, a "higher up" has asked me to make what is already an automated file (created by me) include Fiscal Year totals. What I'm having an issue with is that whenever a new month of data comes in, my "April"(beginning of our fiscal year) column moves to a different column, thus I can't hard code any sort of sums or averages. I need a formula that scans the range of Month titles for April, and then sums up each row in the data set from april on. I've enclosed an example of what I mean. I REALLY hope someone can help me out with this!
Thank you in advance, and I'll be here if there are any questions.