Microsoft has introduced a new feature in Excel that will likely be appreciated by newbies and advanced users alike.
If programming or scripting in general scares you, you don't need to worry either. You don't need to be a programming wizard ...
Excel processes the range (A1:A10) by converting it into an array in memory. This array is what Excel works with to calculate the sum. The distinction is subtle but important: while the range is the ...