Sum If (MS Excel)

SUMIF Adds the cells specified by a given criteria. Syntax SUMIF(range, criteria, sum_range) Range    is the range of cells you want evaluated. Criteria    is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, “32”, “>32”, “apples”. Sum_range    are […]

Continue Reading

Advanced Topics in Excel :

Excel over view The Date in Excel Excel Conditional Formatting Excel VLOOKUP Excel HLOOKUP Using Excel’s Goal Seek Feature Create Excel Pivot Tables Microsoft Excel Sort Feature Introduction to Using Macros in Microsoft Excel 2003 Protect Excel Sheet Data base in excel Copy, paste special function Links (Sheet / work book) Data showing thru Chart […]

Continue Reading