Forum Discussion
Non-Consecutive Cell Referencing
MattKW1 wrote: I've read where someone used a formula using the INDIRECT function but that's beyond my beginner level.
To which I respond, don't sell yourself short. The only way any of us learn without taking courses (and maybe even then)--expecially in Excel--is by playing around with those things we don't yet know. "Playing around" sometimes goes by the term "trial and error." INDIRECT definitely is one of those functions, one of many, where it often takes a bit of trial and error to get it right, but it's truly far better to go through that than to just have the answer handed to you.
May I recommend for future times when you are feeling like you're in over your head that you acquaint yourself with ExcelJet, where there are really helpful descriptions, along with examples, of functions like INDIRECT. I've learned a lot there myself, over recent years, by adding what's shown there with a little bit of playing around myself.
You're not going to break anything by trial and error (I do recommend that you save a backup copy of your workbook first, especially if it's at, you know, work.)