Use Natural Language Formulas Without Using Natural Language Formulas
February 24, 2021 - by Bill Jelen
Challenge: Excel 2003 offers relatively obscure natural language formulas, but they were removed from Excel 2007. The table nomenclature in Excel 2007 isn’t as easy to use.
Solution: To solve this problem, you can use the intersection character in your
SUM function. Everyone knows that
=SUM(A2:A10) sums the nine-cell range from A2 through A10. Most people realize that
=SUM(A1,A3,A5,A7,A9) adds up the five cells specified. However, very few people understand that the space character is actually an intersection operator when used in a