Sumif MS Excel How To

Step by Step: How to Use SumIF in excel 2003, 2007 & 2010 for Sum on a condition

Sumif MS Excel How To. How to sum column data where certain condition meets? Excel has Sum Function that sums up data cells where cells contain digit or numbers in the column on which this formula is applied. A user has to specify certain condition for this purpose. SUMIF is a great and useful formula for taking sum of values which meet certain criteria specified elsewhere.

Step 1:

(a) Sort your data
(b) Formulate your tables: these may be on the same worksheet or on a different worksheet and may even be on other workbooks.
(c) For the sake of example we have created two Tables in d and e:

(d) Table from where data is to be retrieved:

Ms Excel Sumif Function

Ms Excel Sumif Function

(e) Table where data is to be fetched/desired.

Using Excel Sumif

Using Excel Sumif

Step 2:

Ensure spellings for search values are the same in both the tables.

Step 3:

Make sure there is no extra space.

Step 4: Rechecking and reviewing the step by step final Sumif formula

Excel Sumif

Excel Sumif

Final Formula of MS Excel for Sumif

Excel 2007 2010 sumif

Excel 2007 2010 sumif

Result of SUMIf formula excel:

Sumif in excel 2007

Sumif in excel 2007

Advantages of SUMIF formula:

1. You may copy and paste SUMIF formula anywhere within the same sheet or even workbook for sum of numeric values in any column of any worksheet.
2. A really swift and smooth process for summing up columns conditionally across the sheets and workbooks with ease and perfection.

Editor’s Remarks: I have seen the power and magic of MS excel. Where most programs fail you, excel provides you solutions there. However, it is, by any means, not equivalent to those high level languages; however, it does provide quite a few possibilities to the less technical users.