Hi,

Sounds like you have the weekly totals and the daily totals in the same
column. Why not put the weekly totals in a seperate column and then sum that
column? In any case if you want specific answers then you'll need to provide
more details.

Regards!
Jean-Guy

"Blade370" wrote:

I am working on a spreadsheet that has weekly totals stored on it. I want to
attach a summary page that shows the sum of these totals. Is there any way I
can setup the function to pick up the cells that have the weekly totals
without having to select each cell individually?