Add fields across multiple sheets

I am wondering if there is an easier way to add cells in multiple sheets.

I have payroll information in one workbook. Each sheet contains a row with that employees weeks payroll information. I want to create a summary sheet that tally the values in the columns.

Currently I am doing
Sheet1!b2+Sheet2!b2+Sheet3!b2

Is there a way to more easily calculate that without adding individually the 22 payroll periods?
NjamesRRSAsked:
Who is Participating?
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
=SUM(Sheet1:Sheet3!B2)
0
 
NjamesRRSAuthor Commented:
Awesome thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.