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.
(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:
(e) Table where data is to be fetched/desired.
Ensure spellings for search values are the same in both the tables.
Make sure there is no extra space.
Step 4: Rechecking and reviewing the step by step final Sumif formula
Final Formula of MS Excel for Sumif
Result of SUMIf formula excel:
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.