ExcelBanter - working with format 01-01-08

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - working with format 01-01-08 (https://www.excelbanter.com/excel-programming/412618-working-format-01-01-08-a.html)

rwe

working with format 01-01-08

trying to consolidate ragne c51 on 31 sheets with name format 01-01-08 to
01-31-08. =sum('01-01-08':'01-31-08'!C51) doesn't work any suggestions

Mike H

working with format 01-01-08

Maybe

=SUM('01-01-08:01-31-08'!C51)

Mike

"rwe" wrote:

trying to consolidate ragne c51 on 31 sheets with name format 01-01-08 to
01-31-08. =sum('01-01-08':'01-31-08'!C51) doesn't work any suggestions

All times are GMT +1. The time now is 01:58 AM.