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
JohnAsked:
Who is Participating?
 
SteveCommented:
to do between dates would for certain need to be SUMIFS

so like the attached
Util-Sample.xlsx
0
 
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
NBVCCommented:
Try:

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

copied to next column
0
 
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
 
JohnAuthor Commented:
Hello Barman,

Thanks!

John
0
 
SteveCommented:
You are welcome John,

ATB
Steve.
0
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.

All Courses

From novice to tech pro — start learning today.