Okay so I have the attached spreadsheet and the current formula in Column C is not giving me the right output. The correct output can be seen in column D. I need this formula to be able to be dragged out several thousand rows and have it restart every 12 rows as shown. I appreciate your help, thanks!
In C2
=SUM($A$1/12,B2,IFERROR(C1*(MOD(ROW(A1),12)<>1),0))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
This formula, copied down, recalcs each referenced range
Is that something you can work with?
Please Login or Register to view this content.
put this formula in B2, C2 or D2 and fill down
Formula:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks