Join Rudolph Rosenberg for an in-depth discussion in this video Using the SUMIF function, part of Financial Analysis: Analyzing the Top Line with Excel.
- View Offline
…Okay.…So, let's see how to use the sumif function.…To do that let's start with our simple data set and…let's first create a new tab to put our calculations in.…Let's call it analysis And now what we want to do…is first try to calculate how much revenue we have been generating per city for…San Francisco and Los Angeles and let's see then to…calculate how much revenue we've been generating on certain of our products.…
So, to do that let's start by typing the names of the cities that we're trying to…find the revenue for.…Now, let's start with using the sumif function.…To do so, let's type equal S-U-M, and…as you can see, Excel proposes a number of functions that start with those letters.…You can see the second in the list is the summary function we're trying to use here.…So let's double-click on it, and Excel is…proposing the elements that we need to put into that function step by step.…
So, let's start with the range.…What Excel calls the range is in your data,…the information that you want to filter your data on.…
Also check out the companion course, Financial Analysis: Analyzing the Bottom Line with Excel.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Preparing your revenue information
- Comparing past performance
- Analyzing customer data
- Analyzing product information
- Identifying exceptional revenue