- Worldstart's Tech Tips Newsletter - http://www.worldstart.com -
Cell Range Characters in Excel Explained
Posted By On April 23, 2009 @ 3:20 PM In MS Excel,MS Office Help | Comments Disabled
Do you find that referring to cell ranges in Excel formulas is a difficult task? Confused by the use of the colons, commas and spaces?
These characters are definitely a part of formula writing and if they aren’t used correctly, you’ll probably run into some problems.
So, here’s the information that can make formula writing with ranges a much more manageable task.
I should note here that when I did a sum formula using the union it used any overlapping cell values twice – once for each range they’re in. So as a friendly warning, be careful and double check that it’s doing what you intend it to do.
I’ve shown you the results of the identified ranges as highlighted cells, but obviously, when you actually go to use them in formulas, it’s the values within those cells that are put to work.
Now, go forward and confidently use ranges in your formulas to your heart’s content!
Article printed from Worldstart's Tech Tips Newsletter: http://www.worldstart.com
URL to article: http://www.worldstart.com/cell-range-characters-in-excel-explained/