Hello!
I have a spreadsheet that has Jan-Dec as the column heading. Each month, I enter a number into the row under the month heading. I need a formula that will pick up the number in the current month cell, but ignore any that are empty.
For example, I may have a number of 50 under January, 55 for February, 45 for March, but April thru Dec. are still blank. I need the formula to pick up the number of 45 from March, then the next month, I would need the April number. (I cannot total the 12 months because the number I enter is already the year to date number).
After that I need to divide....
There is a "target" number for the year. I need to take the current month total, divide by the target for the year to get a result to show percentage of how close or far off the number is from the target.
I tried using an "if" statement but Excel only allows up to seven if statements, I need 12.
Help please
Bookmarks