Vlookup with Sum

dimbasco

Board Regular
Joined
Jun 2, 2002
Messages
89
Hi...
This is what I am trying to do...
I need to lookup the ID# and then add up all Ranks for the same ID#
For. E.g.
ID # 47 - Total Rank = 1+2+1+1 = 5
Can I use vlookup here?

Thanks in advance,
Dimbasco
rank.xls
ABCD
15ID#TypeRank
1647A1
1747B2
1847C1
1947D1
2048B3
2148C2
2248D2
Sheet3
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Is this what you're asking for?
Book4
ABCDEFG
14
15ID#TypeRankID#
1647A1475
1747B2487
1847C1
1947D1
2048B3
2148C2
2248D2
23
Sheet1
 
Upvote 0
hi dimbasco,

SUMIF is what you should use in this instance. for the example you included in your post, try inserting this formula into an unused cell:

=SUMIF(A:A,"=47",C:C)

this should get you started - adjust to suit your own needs

hth
kevin
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

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