» 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:
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Learn MS Excel 2002 VBA/XML Programming
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Yes, You Can Time the Market!
- Microsoft Access 2002 for Dummies
No comments have been submitted.
