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 and 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 theindexing service can be viewed at the linked Google Scholar™ search.
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.
|Item Type:||Journal Article|
|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|
Repository Staff Only: item control page