» The SUMIF Formula – Using Comparison Operators ( ) as Criteria
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Example:
1. In cell E2, type the criterion 501.
2. In cell D2, insert the SUMIF formula shown in the Formula Bar.
Result:
The SUMIF formula returns only the total of cells B12:B17 because the value of cells A12 to A17 are 501.
Book Store:
Recommended Books:
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Learn MS Excel 2002 VBA/XML Programming
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- The Ernst & Young Business Plan Guide
- Word 2002: The Complete Reference
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
No comments have been submitted.
