All,
I have the following formula in cell B5 of Sheet1: =SUMIF(Employee!B6:GE6,REFERENCES!J$4,Employee!B5:GE5)
I would like to be able to drag it down to B6 but have the formula read as this: =SUMIF(Employee!B8:GE8,REFERENCES!J$4,Employee!B7:GE7)
With the goal that every time I drag it down, it is referencing 2 rows ahead of the previous row. Please let me know if that is a clear enough explanation.
Thank you for your time.
Try this. if it doesn't work, please post an excel sheet.
=SUMIF(OFFSET(Employee!$B$6:$GE$6,(ROWS($1:1)-1)*2,),REFERENCES!J$4,OFFSET(Employee!$B$5:$GE$5,(ROWS($1:1)-1)*2,))
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Try..in B5
=SUMIF(INDEX(Employee!B:GE,(ROW(A1)-1)*2+6,),References!J$4,INDEX(Employee!B:GE,(ROW(A1)-1)*2+5,))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Try
=SUMIF(INDEX(Employee!B:GE,(ROWS($1:1)-1)*2+6,0),REFERENCES!J$4,INDEX(Employee!B:GE,(ROWS($1:1)-1)*2+5,0))
Don't change the $1:1, that is not related to your data
The *2 is the interval (every 2 rows)
The +5 and +6 is the starting Row #s.
Looking the the two subsequent posts, I realise that they're right... I think.
All of the solutions work perfectly! Thank you all.
Yours works too.Originally Posted by Glenn Kennedy
Oh, thanks for that... I didn't test it fully as it's been a bad hair day and I needed a beer; so I was in a bit of a rush.
StudioLETA, thanks for the rep.
Last edited by Glenn Kennedy; 01-09-2015 at 02:41 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks