Steve,
You can reference cells in other sheets by prefixing their cell
coordinates with an exclamation point.
For example:
=week1!a1 + week2!a1 + week3!a1 + week4!a1
Ben
At 06:33 PM 3/26/2014, you wrote:
Hi All,
Using Excel 2010, windows 7 and JAWS 14.
Trying to create a formula in excel that uses the same cell on multiple
sheets, taking weekly figures and adding them up to get a monthly figure.
The layout is the same for the other sheets, therefore the weekly figure
is going to be in the same cell, just on different sheets. So, how would you
suggest I accomplish this to get my monthly figure? We are dealing with
dollars, btw.
Steve and Shannon Cook
Today I married my best friend.
The one that I laugh with, live for, love.
October 11, 2003
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
