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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
Is this what you're asking for?
Book4
ABCDEFG
14
15ID#TypeRankID#
1647A1475
1747B2487
1847C1
1947D1
2048B3
2148C2
2248D2
23
Sheet1
 

kskinne

Well-known Member
Joined
Feb 17, 2002
Messages
1,267
Office Version
  1. 365
Platform
  1. Windows
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
 

dimbasco

Board Regular
Joined
Jun 2, 2002
Messages
89
Yes sir...

Thank you ...
You guys (and of course the gals too) are awesome...

Dimbasco
 

Forum statistics

Threads
1,144,113
Messages
5,722,559
Members
422,447
Latest member
srclife

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
Top