Forum Discussion
Excel
I think you're talking about a reference to a range of cells. But you're making a bigger deal of it than I've heard before.....which may be that I'm too familiar with it so it's "no big deal" with me.
And because you used the word "procedure" in your first post, I mistakenly assumed you were looking for a series of steps, simple steps, rather than a formula, a single formula. Those are all keywords too. 🙂
You'd do well, I think, to get yourself a basic text on Excel and just read it. Start to finish. That will bring things back, maybe even advance them.
Or browse through this website: https://exceljet.net/glossary/range
Thank you very much for your advice.
I have to admit to being very Excel rusty. By trial and error I think I have stumbled across the procedure needed: The best way to describe my previous dilemma is to show an example of the formula I have now used:
= (SUM(E35:E43*J35:J43)/E44)
I would be most grateful if you could give me the excel keyword which defines the process I have used which is much faster and more explicit then entering each of the referenced cells individually.
Cheers, John Dickson
I think you're talking about a reference to a range of cells. But you're making a bigger deal of it than I've heard before.....which may be that I'm too familiar with it so it's "no big deal" with me.
And because you used the word "procedure" in your first post, I mistakenly assumed you were looking for a series of steps, simple steps, rather than a formula, a single formula. Those are all keywords too. 🙂
You'd do well, I think, to get yourself a basic text on Excel and just read it. Start to finish. That will bring things back, maybe even advance them.
Or browse through this website: https://exceljet.net/glossary/range
- Thank you for your advice.