» The SUMIF Formula – Using Comparison Operators ( ) as Criteria
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Use the or comparison operators as criteria in the SUMIF formula.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:
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Mortgages For Dummies®
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Financial Statement Analysis with S&P insert card
- Marketing Plans
No comments have been submitted.
