Adding named ranges actually works!

in Introduction to Excel / Using Named Ranges to Make Formulas More Readable

Presenter said you can't sum named ranges. In this lecture I can type '=SUM(SALES12+SALES13)' and it works (59.5). Maybe newer version of Excel on my end?

0 answers ( 0 marked as helpful)

Submit an answer

related questions

Muhammad Hanafy

Resolved: The Reason for adding Multiplication Mark

Mahmoud Amin

Resolved: vertical axis named wrongly

Alan Gerardo Hurtado Licona

Understanding named ranges

Asim Shamshad

why direct costs are not in cost section instead of adding up in gross margins?

Nguhemen Tingir

Iferror works in some cells but not others

Ric Kipling

Is sumif normally used to add multiple ranges?

Sharon Myburgh

renaming cell ranges

Jasmin Zamora

Whats the purpose of adding the dollar signs in the formula?