ExcelZone Compendium - Practical tips for using SUMIF() and IF()
Posted by AccountingWEB PM | on Thu, 20/09/2007 - 17:52 15185
Practical applications for SUMIF and IF functionsSUMIF: Calculate the sum of all items that match a criterion
COUNTIF: Count the number of entries that match a criterion
Use IF() to avoid error messages, test values and dates
IF() versus MAX() and MIN() in debit and credit columns
Further reading and ExcelZone Any Answers queries
SUMIF and IF are two of the most pop
Continued...
The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.
Registration is FREE and allows you to view all content, ask questions, comment and much more.
Or if you are already registered, login here
Related links
