» 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 Access Version 2002 Step by Step
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Investing for Dummies, Third Edition
- Microsoft Office XP Introductory Concepts and Techniques
No comments have been submitted.
