Posted by
Andrian in
Excel Formulas on
12 26th, 2009 |
no responses
Excel 2007 also add some new functions that not available on previous version, those functions are:
- IFERROR—Used to check for an error, and display a message or perform a different calculation.
- AVERAGEIF— Used to calculate a conditional average (similar to SUMIF and COUNTIF).
- AVERAGEIFS—Used to calculate a conditional average using multiple criteria.
- SUMIFS—Used to calculate a conditional sum using multiple criteria.
- COUNTIFS—Used to calculate a conditional COUNT using multiple criteria.
In addition, worksheet functions that formerly required the Analysis ToolPak add-in (which is shipped with Excel) are now built into Excel. So you have access to dozens of additional functions without installing the add-in.
Related Post
