Naming ranges in Excel

Finau, Glen & Prasad, Acklesh (2015) Naming ranges in Excel. The Accountant: Journal of the Fiji Institute of Accountants, p. 20.


When working with functions in Excel you can reference a range of cells by simply selecting the cells. For instance if you wanted to sum all your first month sales located in the range B3:B16, the function would be =SUM(B3:B16).

Impact and interest:

Citation counts are sourced monthly from Scopus and Web of Science® citation databases.

These databases contain citations from different subsets of available publications and different time periods and thus the citation count from each is usually different. Some works are not in either database and no count is displayed. Scopus includes citations from articles published in 1996 onwards, and Web of Science® generally from 1980 onwards.

Citations counts from the Google Scholar™ indexing service can be viewed at the linked Google Scholar™ search.

Full-text downloads:

12 since deposited on 25 Feb 2016
5 in the past twelve months

Full-text downloads displays the total number of times this work’s files (e.g., a PDF) have been downloaded from QUT ePrints as well as the number of downloads in the previous 365 days. The count includes downloads for all files if a work has more than one.

ID Code: 93240
Item Type: Journal Article
Refereed: Yes
Additional URLs:
Keywords: Excel Tips
Divisions: Current > QUT Faculties and Divisions > QUT Business School
Current > Schools > School of Accountancy
Copyright Owner: Copyright 2015 Fiji Institute of Accountants
Copyright Statement: Reproduction in whole or part of
any text, photograph or illustration without the
written permission of the Executive Director is
Deposited On: 25 Feb 2016 23:08
Last Modified: 02 Mar 2016 02:41

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page