LinkBack URL
About LinkBacks
carolynoi 
Now I feel like a dummy. Of course this will work =SUM(Jan:Dec!D10)
I believe I was over thinking the whole situation. It has to be copied 136 times but this is much simpler that my long formula.
Thank you
Now I feel like a dummy. Of course this will work =SUM(Jan:Dec!D10)
I believe I was over thinking the whole situation. It has to be copied 136 times but this is much simpler that my long formula.
Thank you
If you only had a few months to total...
=INDEX(Jan!D$10:D$1066,ROWS(D$3:D3)*8-8+1)+INDEX(Feb!D$10:D$1066,ROWS(D$3:D3)*8-8+1)+INDEX(Mar!D$10:D$1066,ROWS(D$3:D3)*8-8+1)
Copied down as needed
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks