Todays ms excel lesson 20-11-2011 (sum if)

 

ADDING UP DATA USING SUMIF FUNCTION IN EXCEL

Purpose:

To add up the data available in an array based on a particular field.

Input Data:

Now if you would like to add up and find out how much sales has the salesman “A” or “B” or “C” done in totality. This can be done using pivot table as one option. However let us assume that you wish to calculate their incentive based on the total sales made, you need to use “Sumif” formula function.

How to do

Where do I “Sumif” in Excel 2003 / 2007 / 2010

Since it is a formula, we need to type the same in the format mentioned below

Syntax of the formula

=SUMIF (LOOKUPRANGE, LOOKUPCELL, SUMRANGE)

FORMULA PART

DESCRIPTION

LOOKUPRANGE

This is the column that contains the data that you want to use to filter. For e.g. in our example the column containing Salesman details viz, Column B

LOOKUPCELL

This is a particular cell where you want to find out the output for that. For e.g. you want to find out the sales value of a particular saleman. So we should have that salesman name keyed in a particular cell, which should be used in this formula

SUMRANGE

This is the column that you want to addup. In our example, this would be column “C” and “D”

Hence we should have a small table made as shown below and then execute the formula

 

Click Here To Continue Reading

 

Replies (2)

thanks sir...

 

thanks for sharin sir

cheers

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details