# 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
###### Who is Participating?

Commented:
to do between dates would for certain need to be SUMIFS

so like the attached
Util-Sample.xlsx
0

Billing EngineerCommented:
That would be the function dsum and not vlookup
0

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

Commented:
Try:

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

copied to next column
0

Author 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

Author Commented:
Hello Barman,

Thanks!

John
0

Commented:
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.