How to Add Values Across Multiple Sheets in Excel

How to Add Values Across Multiple Sheets in Excel

Home › Other Content › How to Add Values Across Multiple Sheets in Excel
Sources from the fiX files, • Youtube on Youtube • Published 5 years ago
ChannelPublish DateThumbnail & View CountActions
Channel Avatar the fiX files2019-11-16 03:44:58 Thumbnail
189,741 Views
View on YouTube View Channel
This is a quick video on how to add data from different sheets in Microsoft Excel.

One option is to add the sheets individually in the formula such as:
=SUM(Sheet1!B1+Sheet2!B1+Sheet3!B1)

or you can add a range of sheets using:
=SUM(Sheet1:Sheet2!B1)

Please take the opportunity to connect and share this video with your friends and family if you find it useful.