ssdailypro
New Member
- Joined
- Sep 4, 2010
- Messages
- 12
For Excel 2003 and higher. I am currently using the formula to sum across sheets like this (thank you Aladin for this tip!) on a summary sheet:
{=SUM(IF(ISERR(N(INDIRECT("'"&DAY($A10)+{0,0.2,0.3,0.4,0.5}&"'!C7"))),0,N(INDIRECT("'"&DAY($A10)+{0,0.2,0.3,0.4,0.5}&"'!C7"))))}
This has worked great for the sheets labeled 1,2,3,4 and for any other sheets labeled 1.1, 1.2, 1.3, 2, 3 etc...
However, I am now looking for a similar formula that would be able to handle sheets with 1 (2), 1 (3), 2, 3, etc.
A10 = the day of the month on the summary sheet
C7 = the cell reference on the individual sheets for that month
Thank you for your help.
Scott
{=SUM(IF(ISERR(N(INDIRECT("'"&DAY($A10)+{0,0.2,0.3,0.4,0.5}&"'!C7"))),0,N(INDIRECT("'"&DAY($A10)+{0,0.2,0.3,0.4,0.5}&"'!C7"))))}
This has worked great for the sheets labeled 1,2,3,4 and for any other sheets labeled 1.1, 1.2, 1.3, 2, 3 etc...
However, I am now looking for a similar formula that would be able to handle sheets with 1 (2), 1 (3), 2, 3, etc.
A10 = the day of the month on the summary sheet
C7 = the cell reference on the individual sheets for that month
Thank you for your help.
Scott
Last edited: