Sum the value across multi worksheets

K

Keith F.

I would like to sum the value of several worksheets.
Exmple; 1st Qtr, 2nd Qtr... etc. Have total of all 4
Qtrs. appear on 4th Qtr. worksheet.
I have tried using =SUM(sheet1:sheet4!F35)

Thanks,
 
D

Don Guillett

that WILL work if the value desired is in f35 on each sheet. It will sum
sh1,sh2,sh3,sh4
 
D

Dave Peterson

Is sheet1 to the left of "1st qtr" and is sheet4 to the right of "4th qtr"?

Kind of like a sandwich with all the sheets to be summed the meat and sheet1 and
sheet4 the bread?

If no, try making an excel sandwich.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting or summing up a group of cells with dates as datas 3
date into current and previous quarters 3
vlookup across multiple files returning #N/A 3
Outlining on a protected spreadsheet 1
Excel 2003 4
Formula help 1
copy/paste won't refer to the appropriate range of cells 1
Display minutes ONLY and calc difference 8

Top