Get the SUM of the same ranges from multiple sheets. - VBa

Hi Guys,

Can anyone help me with this? I approximately have 10-15 sheets excluding the home sheet and I need to get the SUM of B11:AF11 (or until blank) for every sheet.

Thank you in advance!

Assuming that you have your 'Home' sheet and then Sheets 2-15, you can write a 3D SUM formula like this:

=SUM(Sheet2:Sheet15!B11:AF11)

Hello,

Thanks for the answer, but my sheets are not named as SheetXX. Will this still work?

Thank you!

Yes. Try it out!

Replace Sheet2 with your first sheet's name and Sheet15 with your last sheet's name.

Hello again,

Apparently the sheets name I have is not fixed tho, its for a report I'm making for the team with that the sheet name will be the name of the associates.

Can you give me a code in VBA instead?

Thank you!

Unfortunately, I cannot assist with VBA. Hopefully somebody else will be able to help you.

up... kindly help