I want to sum the 5th number in a roll starting with column F, e.g. F7, K7, P7, U7........ until HV7.
Can someone tell me how to do it?? Thanks!!
I want to sum the 5th number in a roll starting with column F, e.g. F7, K7, P7, U7........ until HV7.
Can someone tell me how to do it?? Thanks!!
welcome to the forum, parco. maybe:
=SUMPRODUCT((MOD(COLUMN(F7:HV7)-6,5)=0)*F7:HV7)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Do columns F, K, P, U........ until HV7 have the same heading?
If so, then another method would be to use SUMIF()...
=SUMIF($F$1:$HV$1,$F$1,F7:HV7)
You could replace ,$F$1, with the name is you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks