It is not working it says #NAME?

Not sure what you mean by continuous and using shift to select them all

"Daniel CHEN" wrote:

Try to use a function like this:
=SUM(Sheet1:Sheet8!A1)
' Sum all of A1 in 8 sheets.

Sheet1 to sheet8 should be continuous and use shift key to select them all.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================

"Karyn" wrote in message
...
I have a different worksheet for each day of the week which shows the lates
for invoices per department per store. I am trying to create a worksheet
to
add all of the lates per department together for reporting to the POS.