How to Add Numbers in Microsoft Excel if they Meet Certain Criteria

The SumIf function in Microsoft Excel is used to add numbers if they meet certain criteria. Excel's SumIf uses values in ranges of data. There needs to be a minimum of two ranges: at least one range to test criteria against and one range to sum. Excel takes the criteria from the formula and looks for matching information in the criteria range(s). If Excel finds a criteria match, it will add the number in the corresponding sum range. The SumIf formula is composed of three parts: the range of the data being tested, the criteria, which may be a cell or a value, and the sum range.

Print this article

Instructions

- 1
  
  Select "More Functions" from the "Sum" drop-down menu in the "Editing" section on the "Home" tab. This opens the "Insert Function" window.
- 2
  
  Type "sumif" in the "Search For A Function" field and click the "Go" button. Verify that "SUMIF" is highlighted on the "Select a Function" pane and click the "OK" button. This opens the "Function Arguments" window.
- 3
  
  Click in the "Range" field and enter the range of the data that needs to be tested; for example A1:A25 will test each cell starting with A1 and ending with A25 to see if it matches the criteria. The ":" represents "through."
- 4
  
  Click in the "Criteria" field and either type the criteria or enter a cell value. The cell value should contain the criteria.
- 5
  
  Click in the "Sum_Range" field and enter the range of cells that need to be added; for example, B1:B25 will sum any values that match the criteria. The results are displayed in the lower-left corner of the window next to "Formula result =." Click the "OK" button.

Tips & Warnings

The SumIf formula looks like "=SUMIF(Test Range, Criteria, Sum Range)," for example =SUMIF (A1:A25,C1,B1:B25) if the criteria is a cell value or =SUMIF (A1:A25,"text",B1:B25) if the criteria is text. Text criteria must be surrounded by double-quotes.
The SumIf formula can by typed directly into a cell instead of using the Insert Function window.

Suggest item

Comments

How to Use a Letter to Represent a Value in Excel
Microsoft Excel is a program from the Microsoft Office suite that is designed to work with sets of values (mostly numeric) organized...
How to Add Leading Zeros in Excel
When you type a number in Microsoft Excel with leading zeros, Excel removes the zeros by default. This can make entering certain...
How to Add Figures in Microsoft Excel
You can put away your calculator, there is an easier way to add up a number of figures at one time. This...
How to Add Add-Ins for Excel 2007
If you have Microsoft Excel 2007, you may want to install an Excel add-in. Add-ins make the Excel easier to user. For...
How to Add Two Cells in Excel
One of the best things about a spreadsheet is using formulas to calculate values automatically. When you tell Microsoft Excel to add...
How to Add and Round in One Function in Microsoft Excel
How to Round to the Nearest Whole Number. Numbers are rounded to the nearest whole number to eliminate a fraction or the...
How to Add Hours in Microsoft Excel
You can add up times in Microsoft Excel because they are numbers. However, because Excel ignores anything that exceeds 24 hours, you...
How to Add Borders to Cells in Microsoft Excel 2003
Spreadsheet programs, like Excel, make keeping track of finances or create projections easier than ever before. As these programs continue to make...
How to Add a Drop-down to Excel 2007
Microsoft Excel 2007 is useful for creating tracking sheets and multi-function spreadsheets for reports and data logs. If you create a spreadsheet...
How to Remove Add-In Toolbars in Excel 2007
Microsoft Excel 2007 is a spreadsheet program that lets you sort and classify large amounts of data. You can customize Excel with...
How to Add Hours and Minutes in Excel
When you enter numbers in Microsoft Excel, the program assumes that you are using the standard base-10 number system. Therefore, if you...
How to Have Excel Solver Give Only Whole Numbers
Excel Solver is an optimization algorithm produced by Frontline Systems, Inc. that is designed to analyze models of engineering and finance in...
How to Add Grids to a Microsoft Excel Sheet
Adding grid lines to a Microsoft Excel spreadsheet enhances the readability and appearance of the document. Grids outline each cell (or specified...
How to Add Two Cells in Excel 2003
Excel is a spreadsheet program written and distributed by Microsoft. It is one of the most used programs on home and office...
How to Use Excel: Using Sum Function
Excel's preprogrammed functions let your spreadsheet do your math for you. Excel can recalculate values every time you adjust the numbers and,...
How do I Add Area Codes to Phone Numbers in Excel?
If you have an Excel 2010 spreadsheet that contains hundreds or thousands of phone numbers, going through them one-by-one to add an...
How to Add Another Cell to a SUMIF Statement
A SUM+IF statement allows the programmer to utilize the AND and OR logical Boolean expressions. This statement should not be confused with...
How to Create Criteria Ranges in Excel for Database Functions
You can analyze the data in a Microsoft Excel spreadsheet by using database functions, which are a series of calculations. Before you...
How to Generate Random Numbers in Microsoft Excel With More Control
You may be familiar with the RAND function in Microsoft Excel where you can generate random numbers between 0 and 1, like...
How to Add Fractions With Negative Numbers
Fractions, integers, negative numbers, can be confusing. Adding fractions with negative numbers is not as difficult as it sounds. If you can...

How to Add Numbers in Microsoft Excel if they Meet Certain Criteria

Other People Are Reading

Instructions

Tips & Warnings

References

More Like This

Comments

You May Also Like

Related Ads

Kid-Approved iPad Apps by Mom.me

You May Like