How to Add Values Across Multiple Sheets in Excel

How to Add Values Across Multiple Sheets in Excel

HomeOther ContentHow to Add Values Across Multiple Sheets in Excel
ChannelPublish DateThumbnail & View CountActions
Channel Avatar the fiX files2019-11-16 03:44:58 Thumbnail
189,741 Views
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.