Greetings everyone and thank you in advance :-)
I need a formula .
Range D10 to XC10
In XD10 I need a formula to sum values every 6 columns
( D10+J10+P10 and so on)
I tried "=SUM(IF(MOD(COLUMN(D$10:XC$10),6 = 1,D10:XC10,0)))" (CTRL_SHIFT_ENTER)
Excel gives me error and the error highlited is ",6"
In XE10 I will need the same but starting from E10
Last edited by AliGW; 01-15-2019 at 05:53 PM. Reason: [SOLVED]
Hello and welcome to the forum.
Try this:
=SUMPRODUCT(--(MOD(COLUMN(D10:XC10)-COLUMN(D10),6)=0),D10:XC10)
=sumproduct((d10:xc10)*(mod(column(d10:xc10)-4,6)=0))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thank you both. In both formula I get the same error of my formula.
I would attach the file here but I am not allowed and I am not allowed to post links:-(
Yes, you are allowed to post a workbook, but not links.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you !
Here attached my file. (Sorry I feel a little dumb today)
Perhaps your error is coming from a translation issue. It works fine on my end.
I have applied the formula from post #2 in cell A2 and reattached your workbook.
The formula should automatically convert to comply with your regional settings.
Thank you ! Problem solved .
Now I need to locate the cause because I am using the English interface ...
You're welcome. Happy to help.
Thanks for the rep!
Do your formulas use semicolons ";" instead of commas "," ?
At this point I am really confused because I browsed Internet tutorials for 6 hours
...so I definitely love you ! ;-)
After your first reply I copied and pasted the formula you wrote and it did not work.
I come from Openoffice ..I had the same sheet and a formula that worked in Openoffice (not the one I pasted at the beginning of the post). I do know that Excel will make my job easier but for now I am totally stuck.
The next step is that I have to adapt a OO Macro to Excel and I am really considering to reach the "commercial services" because I do not want to abuse of other people time and Job ;-)
Once again a HUGE Thank you !
The correct way to mark a thread as solved is to select Thread Tools from the menu link above and mark this thread as SOLVED. I have done it for you this time.
Got it .
Thank you AliGW :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks