Improve company productivity with a Business Account.Sign Up

x
?
Solved

VLOOKUP Calculation

Posted on 2013-01-23
7
Medium Priority
?
312 Views
Last Modified: 2013-01-23
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
Comment
Question by:John
7 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38811277
That would be the function dsum and not vlookup
0
 
LVL 24

Expert Comment

by:Steve
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

by:NBVC
ID: 38811328
Try:

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

copied to next column
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 

Author Comment

by:John
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

by:
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

by:John
ID: 38811487
Hello Barman,

Thanks!

John
0
 
LVL 24

Expert Comment

by:Steve
ID: 38811763
You are welcome John,

ATB
Steve.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

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

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

Join & Ask a Question