• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

VLOOKUP Calculation

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
John
Asked:
John
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
That would be the function dsum and not vlookup
0
 
SteveCommented:
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
 
NBVCCommented:
Try:

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

copied to next column
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
JohnAuthor Commented:
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
 
SteveCommented:
to do between dates would for certain need to be SUMIFS

so like the attached
Util-Sample.xlsx
0
 
JohnAuthor Commented:
Hello Barman,

Thanks!

John
0
 
SteveCommented:
You are welcome John,

ATB
Steve.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now