in a column, if i want to sum up every 13th cell moving down, i.e. starting at D5, then D18, D31, etc., how would i do that?
formulas i have seen during searches are not working for me
in a column, if i want to sum up every 13th cell moving down, i.e. starting at D5, then D18, D31, etc., how would i do that?
formulas i have seen during searches are not working for me
Do you want running sum?
If start from row 5:
=IF(MOD(ROW(5:5)-5,13)=0,SUMPRODUCT((MOD(ROW($5:5)-5,13)=0)*$D$5:D5),"")
Quang PT
very close, i dont need a running sum, just one at the top of the column or in another single cell
and want it so it continues every 13th cell down for a long run, as it could vary, but be more than i would want to continuously type in
thanks!
not sure if this screenshot uploaded
Attachment 752052
How aboutFormula:Please Login or Register to view this content.
this works, thank you so much!
Glad to help & thanks for the feedback.
one other thing. this works great for one column, and i could use that formula on a summary tab as well, and it still worked. If i wanted to add up the column D's from several tabs, how would i do that?
For example:
This lets me capture every the sum of 13th cell in Column D from another tab (ADMIN) on a front cover sheet summary tab.
=sumproduct((MOD(ROW(ADMIN!D5:D1000)-5,13)=0)*ADMIN!D5:D1000)
But if i wanted to have the sum from several tabs, each the same Column D, every 13th cell, how would i do something like that?
The below doesnt work, and was just a long shot from my remedial excel formula knowledge
=sumproduct((MOD(ROW(ADMIN!D5:D1000)-5,13)=0)*ADMIN!D5:D1000),((MOD(ROW(ADMIN2!D5:D1000)-5,13)=0)*ADMIN2!D5:D1000),((MOD(ROW(ADMIN3!D5:D1000)-5,13)=0)*ADMIN3!D5:D1000)
How aboutFormula:Please Login or Register to view this content.
this is perfect, thank you!
My pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks