Thread
:
adding values across worksheets in a spreadsheet
View Single Post
#
2
Andy Brown
Posts: n/a
"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
Reply With Quote