SUMIF Function | SUMIF Function in Excel | Micorosoft Office training
The tutorial of the day is “SUMIF Function”, which is also an important function of Microsoft Excel so therefore today we will work on it. To learn it, follow the steps which are given below.
1) Start “Microsoft Excel 2007”.
2) Write these information on Excel datasheet as given below.
3) Now we want to SUM “Doctors” salary, we have 2 “doctors” in our list and now we want SUM their salary, To SUM their salary, type this Function (=SUMIF(D4:D11,"Doctor",E4:E11)) as given below.
4) Our function means that SUM all “Doctors” Salary which is on “Salary” column.
(D4 and D11 is the area of cell which means that select from D4 cell to D11) after that we should type a Position of an Employee which is “Doctor” and the last one is (E4:E11) which is the area of Salary so the complete meaning of our function is in easy words (Sum all “Doctors” salary which is in selected range of table)
5) After type of function press “Enter”, After Enter you will see “1250$”, which is the SUM salary of 2 doctors.
0 comments:
Post a Comment