Excel’s Sumif and Sumifs function

Finau, Glen & Prasad, Acklesh (2015) Excel’s Sumif and Sumifs function. The Accountant: Journal of the Fiji Institute of Accountants, p. 33.


As accountants, we are all familiar with the SUM function, which calculates the sum in a range of numbers. However, there are instances where we might want to sum numbers in a given range based on a specified criteria. In this instance the SUM IF function can achieve this objective.

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:

58 since deposited on 25 Feb 2016
58 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: 93237
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 [Please consult the author]
Deposited On: 25 Feb 2016 22:45
Last Modified: 02 Mar 2016 02:28

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page