CATEGORY: Summing VERSIONS: 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.

Screenshot // The SUMIF Formula – Using Comparison Operators ( ) as Criteria

Rate this tip 1 2 3 4 5   RATING: 2.47   VIEWS: 30607 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction Microsoft Windows XP Registry Guide Guide to Financial Reporting and Analysis Positioning: The Battle for Your Mind East of Eden (Oprah's Book Club) Special Edition Using Microsoft Excel 2002

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books