Sum total on row that increments by 2 columns when increasing input cell by 1

Excel 2010
I have a input cell to enter a period number – Eg 1, 2, 3 …. up to 18

I want to return sum total in output cell that totals for example

For 1 will return sum(J10:L10)
For 2 will return sum(J10:N10)
For 3 will return sum(J10:P10)
Etc etc ie for each increment of 1 in period input cell adds in 2 further columns tot the total sum.

At present I have a messy nested if formula.

Can you help?


By: Penny

25 thoughts on “Sum total on row that increments by 2 columns when increasing input cell by 1

  1. kevin durant shoes

    Needed to compose you this little observation to be able to give many thanks as before about the great pointers you have provided in this case. It was quite particularly open-handed of you to deliver unhampered what a few people might have advertised as an ebook to earn some cash for their own end, most notably now that you might have done it if you considered necessary. The basics in addition acted as a great way to understand that some people have a similar desire the same as my own to learn whole lot more in respect of this matter. I believe there are lots of more pleasurable sessions in the future for individuals that looked at your blog post.

  2. ig

    It’s really very complex in this active life
    to listen news on Television, therefore I simply use web for that reason, and take the latest information.

  3. Fredrick

    I have to thank you for the efforts you’ve put in writing this blog.
    I really hope to see the same high-grade content by you later on as well.

    In fact, your creative writing abilities has encouraged me to get my own blog now 😉

  4. nike react

    I truly wanted to develop a quick note so as to appreciate you for the superb tricks you are giving at this site. My time-consuming internet lookup has now been rewarded with awesome facts and strategies to go over with my best friends. I ‘d repeat that many of us site visitors are very much fortunate to be in a magnificent community with very many awesome people with valuable suggestions. I feel very blessed to have seen your webpage and look forward to really more brilliant moments reading here. Thank you again for all the details.

  5. air max

    Thanks for every one of your efforts on this web site. Betty takes pleasure in getting into investigation and it’s really obvious why. Almost all learn all about the compelling medium you present reliable tricks on your blog and as well boost contribution from other individuals on this matter while our favorite girl is actually starting to learn a great deal. Take pleasure in the remaining portion of the year. Your carrying out a stunning job.

  6. adidas tubular

    Thank you so much for providing individuals with such a special possiblity to read critical reviews from here. It is often so kind plus packed with fun for me and my office co-workers to search your blog the equivalent of thrice every week to read the newest guides you will have. And definitely, I’m usually motivated considering the good tricks you give. Some 3 facts in this posting are completely the best I have ever had.

  7. nike air max 90

    Thanks a lot for providing individuals with an extraordinarily wonderful possiblity to check tips from this website. It is usually so ideal and jam-packed with fun for me and my office co-workers to search your web site at the least thrice every week to read the latest guides you have got. And of course, I’m at all times contented considering the wonderful knowledge you give. Selected two facts in this post are without a doubt the simplest I have had.

  8. coach outlet

    I wanted to create you this bit of note to help thank you as before for the pleasant pointers you’ve discussed at this time. It is surprisingly open-handed with people like you to make publicly what a number of people might have advertised as an ebook to end up making some cash on their own, primarily considering that you could have tried it if you ever considered necessary. Those solutions as well acted to become a good way to fully grasp many people have a similar fervor similar to my personal own to know the truth a lot more with reference to this matter. I think there are lots of more enjoyable moments ahead for many who read your blog.

  9. curry 4 shoes

    I’m also writing to let you understand what a magnificent experience my wife’s princess had using your site. She learned too many things, which include what it is like to possess an excellent helping nature to make other people effortlessly learn some problematic subject areas. You undoubtedly surpassed people’s expectations. Many thanks for giving such powerful, dependable, revealing and easy tips about that topic to Julie.

  10. yeezy shoes

    I happen to be commenting to make you know of the amazing encounter my wife’s child undergone browsing yuor web blog. She even learned lots of details, most notably how it is like to have a wonderful helping spirit to let others completely grasp a variety of tricky matters. You actually surpassed our desires. Many thanks for imparting these helpful, safe, explanatory and as well as easy thoughts on the topic to Sandra.

  11. yeezy boost 700

    My husband and i felt quite thankful Ervin managed to finish off his reports from your precious recommendations he came across through the blog. It’s not at all simplistic just to possibly be giving for free concepts which usually a number of people could have been making money from. We discover we now have the writer to give thanks to because of that. Most of the illustrations you made, the easy site menu, the relationships you can help to foster – it is everything terrific, and it’s really making our son in addition to our family recognize that this subject matter is pleasurable, which is especially vital. Thanks for all!

  12. yeezy

    Thank you for each of your efforts on this blog. Betty delights in conducting investigation and it’s really easy to understand why. Almost all learn all regarding the powerful tactic you give very useful guides via your blog and even inspire participation from website visitors on this matter so our own princess has always been studying so much. Take pleasure in the rest of the year. You’re doing a pretty cool job.

  13. bape hoodie

    I have to convey my affection for your generosity for people that absolutely need help on this important matter. Your very own dedication to getting the message all around came to be extraordinarily insightful and have surely made associates like me to arrive at their ambitions. The helpful information denotes this much a person like me and substantially more to my fellow workers. Regards; from each one of us.

  14. curry 6 shoes

    I must express some appreciation to this writer for bailing me out of such a setting. As a result of scouting through the online world and coming across opinions that were not powerful, I figured my life was over. Living without the strategies to the issues you have solved as a result of your main article content is a crucial case, as well as the kind which may have badly damaged my career if I hadn’t noticed your web page. Your good natural talent and kindness in controlling every aspect was precious. I don’t know what I would have done if I hadn’t come across such a thing like this. I’m able to at this time look ahead to my future. Thank you so much for the high quality and amazing guide. I will not be reluctant to suggest your site to anyone who would like direction about this subject.

  15. hermes birkin

    Needed to compose you the bit of observation to help thank you so much the moment again considering the remarkable principles you have provided on this website. It has been certainly shockingly open-handed with people like you to offer easily precisely what a few individuals would’ve marketed for an e-book to end up making some profit for their own end, chiefly now that you might have tried it in the event you wanted. These concepts as well worked as a easy way to fully grasp that the rest have the same dream just like mine to understand a lot more with reference to this condition. I’m certain there are some more pleasant instances in the future for many who take a look at your blog post.

  16. mbt shoes

    Thanks a lot for providing individuals with a very pleasant possiblity to discover important secrets from this site. It is often very lovely and as well , full of a good time for me and my office acquaintances to visit your site at a minimum three times in one week to see the latest items you will have. And definitely, I am just actually amazed with your amazing things served by you. Selected 3 facts in this posting are certainly the finest we have all had.

  17. bape hoodie

    I needed to write you the tiny note to finally give many thanks yet again on your beautiful advice you’ve discussed on this site. This has been so open-handed with people like you to supply extensively exactly what numerous people would’ve made available as an ebook to make some profit for themselves, specifically given that you could possibly have done it in the event you decided. These suggestions in addition acted to be the easy way to fully grasp some people have the same eagerness just as my personal own to see good deal more related to this issue. Certainly there are numerous more pleasant times ahead for individuals that look into your site.

  18. yeezy sneakers

    Aw, this was a very nice post. In thought I would like to put in writing like this moreover ?taking time and actual effort to make an excellent article?however what can I say?I procrastinate alot and on no account seem to get something done.

  19. nike kd 11

    I抦 impressed, I have to say. Really hardly ever do I encounter a blog that抯 each educative and entertaining, and let me inform you, you’ve gotten hit the nail on the head. Your thought is excellent; the problem is something that not sufficient persons are speaking intelligently about. I am very happy that I stumbled throughout this in my search for one thing regarding this.

  20. yeezy shoes

    I discovered your blog site on google and test a few of your early posts. Proceed to keep up the superb operate. I just additional up your RSS feed to my MSN Information Reader. Searching for ahead to studying extra from you in a while!?

  21. nike air max 97

    Can I just say what a aid to search out someone who actually knows what theyre talking about on the internet. You definitely know methods to deliver a difficulty to mild and make it important. Extra people must learn this and understand this aspect of the story. I cant imagine youre not more well-liked because you definitely have the gift.

Comments are closed.