summing same cell in multiple worksheets

[Sinkguy1]

Is there an easy formula to sum the same cell from multiple worksheets
without typing each one? =sheet2 b3+sheet3 b3+sheet4 b3 etc.. Is there a
formula that will sum cell B3 from all sheets in the workbook?

 

[Teethless mama]

=SUM(Sheet2:Sheet5!B3)

 

[Sinkguy1]

Thanks, I knew there had to be a way to do it. Works Great!

 

[Teethless mama]

You're Welcome!

Thanks, I knew there had to be a way to do it. Works Great!