How do I add all "B1" cells on each worksheet?

  • Thread starter Church Accountant
  • Start date
C

Church Accountant

I have automated a time sheet that copies and saves each time period in a new
worksheet. Each sheet has Regular Time, Overtime, Sick, Vacation, etc.

On my home page, I would like to be able to add all of the 'Regular Time'
amounts from each sheet. The individual time sheets are not created until
the time sheet is completed and printed, so I can't simply write a formula to
pull information from a worksheet name.

In Quattro Pro (I know...Quattro what?), there was a 'bullet' function that
would do this. Does anyone know of a way to sum all of the 'B1' cells in a
spreadsheet?
 
B

bpeltzer

They're called 3D Sums. Ex: =sum('Sheet 1:Sheet 3'!B1). Only the sheets
from Sheet 1 through Sheet 3 would be included in the sum, so I often create
dummy worksheet sheets just to mark the beginning and end of my sum range.
--Bruce
 

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

Calc staff vacation time based on more than 1 criteria 0
list sheet 1 - same cell (eg A1) in a group of worksheets sheet 2
2007-Delete only 1 row of objects on worksheet, not all of them. 0
Highlighting multiple triggers 4
Payroll Calculations 3
How do I create a detailed Timesheet? 1
SUM function on multiple worksheet 5
How can I reference a worksheet in a formula based on a cell value 2

Top