Friday, March 1, 2013

Excel: Sum Value of Same Cell Across Multiple Sheets

Heres a tip how to sum value of the same cell across multiple worksheets:

=SUM(Sheet1:Sheet3!B3)

This sums cell B3 from Sheet1, Sheet 2 and Sheet 3 - voilá!

No comments:

Post a Comment