#### 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: