Sorry if this has been answered elsewhere, I have been searching for hours to no avail---
I am trying to sum B11 and B12 of sheet1 on cell B18 of sheet2. Then in cell C18 of sheet2 I want it to sum D11 and D12 of sheet1. Then in cell D18 of sheet2 I want it to sum F11 and F12 of sheet1. Basically skipping a column in each cell. How can this be done?
Thanks in advance!
=SUM(Sheet1!B11:B12)
copy paste and drag to right its simply relative cell referncing
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
That does not work. That will not skip a column. C18 would then reference Sheet!C11:C12 instead of Sheet!D11:D12
=SUM(OFFSET(Sheet1!$B$11,0,(COLUMN(B18)-COLUMN($B18))*2,2,1))
Hi
Use the following formula in Sheet2! B18
Formula:
=SUM(OFFSET( Sheet1!$B11:$B12,0,2*(COLUMN(A$1)-1)))
Regards
Fantastic, Jose--I used yours and it worked perfectly. Thanks everyone for your assistance!
oops misreaded
=SUM(INDEX(sheet1!$B$11:$P$12,,((COLUMN(A1)*2))-1))
change the references according to your data
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks