Need help with INDEX possibly OFFSET formula
This is the formula
=SUM(Sheet2!A2:A10)
What i've been trying to do is as I drag down the column to have the formula change to
=SUM(Sheet2!B2:B10) and so on.
Basically is what happens we drag to the right we get an increment on the column letter, but I want it when I drag down.
I'm trying to accomplish this on Sheet1 btw if that affects on how to write the formula. I've tried on my own multiple times but keep coming up with REF#
Try
=SUM(INDEX(INDEX(Sheet2!$A$2:$Z$10,0,ROW(A1)),0))
Copy down
Last edited by Ace_XL; 06-18-2013 at 04:05 PM.
Life's a spreadsheet, Excel!
Say thanks, Click *
All that did was gimme a 0 when B1 should = 10 B2=20 B3=30 so on. Anymore ideas or should it matter that i'm putting it in column B in sheet 1?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks