The Excel Formula : SUMIF

Dear Friends.

We sometimes required to sum the value in the given range with certain criteria. It is very painful and time taking tasks if you have to do this manually, specially in a large database. So, here you will find the ways to get the output within seconds using the Excel inbuilt formulas.

		ColumnC	ColumnD	ColumnE
	Row3	Item	Date	Cost
	Row4	Brakes	01-Jan-98	80
	Row5	Tyres	10-May-98	25
	Row6	Brakes	01-Feb-98	80
	Row7	Service	01-Mar-98	150
	Row8	Service	05-Jan-98	300
	Row9	Window	01-Jun-98	50
	Row10	Tyres	01-Apr-98	200
	Row11	Tyres	01-Mar-98	100
	Row12	Clutch	01-May-98	250
	Total cost of all Brakes bought.				160	=SUMIF(C4:C12,"Brakes",E4:E12)
	Total cost of all Tyres bought.				325	=SUMIF(C4:C12,"Tyres",E4:E12)
	Total of items costing £100 or above.				1000	=SUMIF(E4:E12,">=100")
	Total of item typed in following cell.			service	450	=SUMIF(C4:C12,E18,E4:E12)
	What Does It Do ?
	This function adds the value of items which match criteria set by the user.
	Syntax
	=SUMIF(RangeOfThingsToBeExamined,CriteriaToBeMatched,RangeOfValuesToTotal)
	=SUMIF(C4:C12,"Brakes",E4:E12)			This examines the names of products in C4:C12.
				It then identifies the entries for Brakes.
				It then totals the respective figures in E4:E12
	=SUMIF(E4:E12,">=100")			This examines the values in E4:E12.
				If the value is >=100 the value is added to the total.
	Formatting
	No special formatting is needed.

For any confusion, feel free to comment or mail at sharma.ctc@gmail.com