smashclash
Board Regular
- Joined
- Nov 24, 2003
- Messages
- 126
- Office Version
- 365
- Platform
- Windows
I have a file that contains worksheets for every month and a YTD worksheet. The YTD worksheet is suppose to sum up all the data from the prior month worksheets. There are 2 columns on each month's worksheet - ACTUAL and BUDGET. The budget information is already filled in on every sheet for the year. Actual data is filled in as the months of the year pass. The problem I'm wrestling with is I want to the YTD file to only add information from the month worksheets if there is data in the ACTUAL columns. Right now I'm stuck with 12 months worth of BUDGET in my YTD file and its compared against only 2 months of ACTUAL data.
What I am trying to do is come up with a formula that will check cell E14 (the first cell that will contain ACTUAL data) in each worksheet to see if there is any data there. If there is data there, then add the data in cell G14 (the first cell that will contain BUDGET data). This YTD sheet needs to be able to look at all 12 month sheets and add them if there is data in cell E14. Does anyone have a suggestion for a formula that would work?
Below is a copy of my file:
What I am trying to do is come up with a formula that will check cell E14 (the first cell that will contain ACTUAL data) in each worksheet to see if there is any data there. If there is data there, then add the data in cell G14 (the first cell that will contain BUDGET data). This YTD sheet needs to be able to look at all 12 month sheets and add them if there is data in cell E14. Does anyone have a suggestion for a formula that would work?
Below is a copy of my file: