[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# VLOOKUP Calculation

Posted on 2013-01-23
Medium Priority
308 Views
Hello,

I am trying to perform a lookup where I want to find the reference in column A and total the amounts in columns B or C. As you will see in my attached sample, I have a list of utilities in column A. In column B I have the cost and in Column C I have the amount paid.

In Column E I want to get the total cost for Electric and in Column F I want the total paid.

How do I find and total up all occurrences of Electric.

Thanks,

John
Util-Sample.xlsx
0
Question by:jpldpd

LVL 143

Expert Comment

ID: 38811277
That would be the function dsum and not vlookup
0

LVL 24

Expert Comment

ID: 38811278
you can just use SUMIF... see attachment 1.

or you can use SUMIFS on normalised data... see attachment 2.
Util-Sample.xlsx
Util-Sample.xlsx
0

LVL 23

Expert Comment

ID: 38811328
Try:

=SUMIFS(B\$2:B\$9,\$A\$2:\$A\$9,\$E\$1)

copied to next column
0

Author Comment

ID: 38811354
Hello Barman,

Thanks! One last question,  what if I wanted to include a date and look for all Utilities within a date range? For example I want a total of all bills from 01/01/2013 through 01/31/2013. Would that sill be a SUMIF?

Thanks,

John
0

LVL 24

Accepted Solution

Steve earned 2000 total points
ID: 38811432
to do between dates would for certain need to be SUMIFS

so like the attached
Util-Sample.xlsx
0

Author Comment

ID: 38811487
Hello Barman,

Thanks!

John
0

LVL 24

Expert Comment

ID: 38811763
You are welcome John,

ATB
Steve.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are â€¦
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilâ€¦
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
###### Suggested Courses
Course of the Month18 days, left to enroll

#### 829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.