ANTONIO1981
Board Regular
- Joined
- Apr 21, 2014
- Messages
- 162
Dear all
I have the following spreadsheetI would like to create a formulae in T4 based on a dynamic value placed in cell T2.
My target is to calculate Sum all months to get to a YTD value (YTD=year to date) .
Example: May 16 YTD = January+ February+March+April+May
The issue that i have is that i need to ignore the greyed cells ( cells that sum quarters)
I tried with OFFSET But it doesn't ignore particular cells.
thanks in advance
Antonio
I have the following spreadsheetI would like to create a formulae in T4 based on a dynamic value placed in cell T2.
My target is to calculate Sum all months to get to a YTD value (YTD=year to date) .
Example: May 16 YTD = January+ February+March+April+May
The issue that i have is that i need to ignore the greyed cells ( cells that sum quarters)
I tried with OFFSET But it doesn't ignore particular cells.
thanks in advance
Antonio