Adding non continuous cells (A3 A6 A9 etc) from different sheets

I am trying to add cells from differnet sheets that are also not consecutive. So for example, I want to add AA3+AA6+AA9+AA12 from sheet 1 onto sheet 2. I have found two formulas that work when the data is in the same sheet:

 

=INDIRECT(“AA” & 3+(ROW()-1)*3)

 

=INDEX(AA:AA,(ROW(AA1)-1)*3+3)

  However when I add sheet1! in, I get an error. If there is a way to make this add multiple sheets, that would be ideal…like if this would work: =sheet1!INDIRECT(“AA” & 3+(ROW()-1)*3)+sheet2!(“AA” & 3+(ROW()-1)*3)+sheet3!(“AA” & 3+(ROW()-1)*3)


 

I am using 2016 Excel Mac. 

 

By: Kacy

4,182 thoughts on “Adding non continuous cells (A3 A6 A9 etc) from different sheets

  1. udfauzi

    Hello! I could have sworn I’ve visited this site before but after going through a few of the articles I realized it’s new to me. Anyways, I’m certainly pleased I found it and I’ll be book-marking it and checking back regularly!

  2. udfauzi

    May I just say what a comfort to find someone who actually understands what they’re discussing on the web. You certainly know how to bring a problem to light and make it important. A lot more people need to read this and understand this side of your story. It’s surprising you are not more popular given that you definitely possess the gift.

  3. genolyze.com

    I blog frequently and I genuinely thank you for your content. This great article has really peaked my interest. I am going to bookmark your blog and keep checking for new information about once a week. I subscribed to your Feed too.

  4. tokoonline88.com

    Hi, I do believe your website could be having web browser compatibility problems. When I look at your site in Safari, it looks fine however, if opening in IE, it’s got some overlapping issues. I merely wanted to provide you with a quick heads up! Besides that, excellent website!

  5. harga jual.com

    I wanted to thank you for this wonderful read!! I definitely enjoyed every little bit of it. I’ve got you bookmarked to look at new things you post…

  6. Moedah

    Hello! I could have sworn I’ve visited this website before but after looking at a few of the posts I realized it’s new to me. Nonetheless, I’m definitely pleased I came across it and I’ll be book-marking it and checking back regularly!

  7. download apk vivoslot

    I’m impressed, I have to admit. Seldom do I encounter a blog that’s both equally educative and entertaining, and without a doubt, you have hit the nail on the head. The problem is something that too few men and women are speaking intelligently about. I’m very happy I stumbled across this during my search for something relating to this.

  8. download aplikasi vivo slot

    I blog often and I really appreciate your content. The article has truly peaked my interest. I am going to take a note of your blog and keep checking for new details about once a week. I opted in for your Feed too.

  9. aplikasi vivoslot

    You made some really good points there. I checked on the web for additional information about the issue and found most individuals will go along with your views on this web site.

  10. daftar vivoslot

    I was more than happy to discover this page. I need to to thank you for ones time due to this fantastic read!! I definitely really liked every little bit of it and I have you book marked to see new things on your web site.

  11. site,

    Hello, i feel that i noticed you visited my web site so i got here to return the desire?.I am trying to in finding
    things to enhance my web site!I guess its ok to make use of a few
    of your concepts!!

  12. fancy text

    I blog often and I genuinely thank you for your information. Your article has truly peaked my
    interest. I’m going to book mark your blog and keep checking
    for new information about once a week. I opted in for your Feed
    too.

  13. https://www.clars.dk/

    Aw, this was a гeally nice рost. Taking a few minutes
    and actuɑl effort to create a ѵery good article…
    but what cаn I say… I put things ߋff а whoⅼe lot and don’t manage to get nearly anything done.

  14. slot online

    Right here is the right website for everyone who hopes to find out about this topic. You realize so much its almost hard to argue with you (not that I really will need to…HaHa). You certainly put a brand new spin on a topic that has been discussed for many years. Wonderful stuff, just wonderful!

  15. مكاتب شحن

    Hello there, just became aware of your blog through Google, and found that it is really informative.
    I am gonna watch out for brussels. I will appreciate if you continue
    this in future. Lots of people will be benefited from your writing.
    Cheers!

  16. dingdongtogel.com

    Can I just say what a relief to uncover somebody that genuinely understands what they’re talking about online. You certainly know how to bring a problem to light and make it important. More and more people need to read this and understand this side of your story. I can’t believe you’re not more popular because you surely have the gift.

  17. 谷歌优化

    I have been exploring for a little for any high-quality
    articles or weblog posts on this kind of area . Exploring in Yahoo I finally stumbled upon this web site.
    Reading this information So i’m glad to show that I have a very good uncanny feeling I found out exactly what I needed.
    I such a lot surely will make sure to don?t overlook this website
    and give it a glance on a continuing basis.

Comments are closed.