I would like to drag my formula down and skip every other row, but still only adjust the formula by one row
ex
DESIRED RESULT
1ST ROW A1+B1
2ND ROW BLANK
3RD ROW A2+B2
4TH ROW BLANK
5TH ROW A3+B3
DRAGGING 1ST AND 2ND ROW DOWN RESULTS IN
1ST A1+B1
2ND BLANK
3RD A3+B3
4TH BLANK
5TH A5+B5
Any Ideas I may need to come at this from a totally different direction.
is there another criteria you could be using to do the sum instead of just A+B? maybe attaching a sample sheet coudl spark some ideas.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Try...in C1
=IF(MOD(ROWS(C$1:C1),2),SUM(INDEX(A$1:B$1000,INT((ROWS(C$1:C1)-1)/2)+1,0)),"")
Change C$1:C1 to your start cell
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks