need help in the formula

[sksanjeev786]

Hi Team,

I have a project named "Airbnb" in multiple sheets and I need total hours (column B)for all the sheets in 1 sheet.

Can anyone help me with this.

Regards
Sanjeev

 

[bobsan42]

if all the sheets to sum are consecutive then you can use a 3D formula like this:

=SUM(Sheet2:Sheet4!B:B)