Vlookup summing

kikik

New Member
Joined
Dec 19, 2005
Messages
31
I'm using the vlookup to capture financial data from another worksheet. The problem is that some names are listed more than once. I need to sum up all salaries. Ex John Doe listed 3 time with $5, $3, and $2 and need to add them together.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Not sure what you are using the VLOOKUP for, but perhaps SUMIF:

=SUMIF(Sheet2!A1:A100,"John Doe",Sheet2!B1:B100)
 
Upvote 0
hotpepper, there's nothing wrong with what you said, but I'll mention that when I give sumif examples I usually add the $ anchors, having myself been beaten up by that so many countless times. ( Generally, I try to condition myself to add them immediately after constructing a SUMIF. Too bad you can't type $ while entering the formula (that is, when you navigate the ranges). )
 
Upvote 0
THanks sumif works. Can it add columns and rows together?
If have names(could be more than once) in A and and amounts in b,c,d.
 
Upvote 0
kikik said:
THanks sumif works. Can it add columns and rows together?
If have names(could be more than once) in A and and amounts in b,c,d.

Try,

=SUMPRODUCT(($A$1:$A$10="Name")*($B$1:$D$10))
 
Upvote 0
I don't know what the behavior means when the sum range is not dimensioned precisely the same as the lookup range for SUMIF. I would add several SUMIFs.

Actually, I retract that last lament I made about typing $. I just remembered that the amazing Aladin identified that you can use the F2 key to toggle navigation and typing.
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,993
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top