ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   adding values across worksheets in a spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/21897-adding-values-across-worksheets-spreadsheet.html)

ed java

adding values across worksheets in a spreadsheet
 
I have a spreadsheet with monthly worksheets. Is there a way to add up the
values of the same cell from each month at the end of the year to get a
yearly total?

Andy Brown

"ed java" <ed wrote in message
...
I have a spreadsheet with monthly worksheets. Is there a way to add up

the
values of the same cell from each month at the end of the year to get a
yearly total?


Assuming they're in order, try something like:

=SUM(Jan:Mar!A1)

HTH,
Andy




All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com