[Solved] Looking at a Column with multiple Occurrences of a Value, pulling a # value from each occurrence and adding them together

DaOrks

New member
Good morning!

Hopefully my question makes sense but I've got two pictures below to assist.

Essentially the first image is in a sheet named 'WIP Tracker' (Blue one)
Second image is a 'OCT_TDR', its a report I can just print/paste into excel.

I am trying to take the Voyager Card ID in the F column of the WIP Tracker sheet, read down the D column of the 'OCT_TDR' sheet for each time that Card ID is shown and pull the J column of the 'OCT_TDR' then sum them all together.

So pretty much, Card ID 700251, read into the D column, it shows up say 3 times, for a charge of 20.00, 10.50 and 30.50. So it returns a 61.00 to the L column of the tracker page.

I know I can lookup for single values, but I can't figure out a way with any various lookup functions to pull multiple iterations of the Card ID and sum them up.

Example 1 .pngExample 2.png
 

Online statistics

Members online
0
Guests online
6
Total visitors
6

Forum statistics

Threads
383
Messages
1,676
Members
725
Latest member
huroy771
Back
Top