ExcelBanter - what formula do I use to add sums from other worksheets to a sum s

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - what formula do I use to add sums from other worksheets to a sum s (https://www.excelbanter.com/new-users-excel/193752-what-formula-do-i-use-add-sums-other-worksheets-sum-s.html)

Louise

what formula do I use to add sums from other worksheets to a sum s

What formula do I use to add sums from multiple worksheets into a summary
sheet, and how many sheets can I add?

Don Guillett

what formula do I use to add sums from other worksheets to a sum s

suggest they are dummies and you actually sum the ones in between.
=sum(sheetfirst:sheetlast!a1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Louise" wrote in message
...
What formula do I use to add sums from multiple worksheets into a summary
sheet, and how many sheets can I add?

All times are GMT +1. The time now is 10:49 AM.