Vlookup to find a count of identical row matches

[FinanceDude2420]

Currently, I have a formula that only selects the first number found. What I want to do is add up all those matches. Please see info below.

Here's the formula I currently use....

=IF(ISNUMBER(VLOOKUP($B1782,'Transfer Data'!$A$3:$G$22042,6,0)),VLOOKUP($B1782,'Transfer Data'!$A$3:$G$22042,6,0),0)

It is referencing the "Reference" column to vlookup.


[TABLE="width: 1492"]
<TBODY>[TR]
[TD][TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD][TABLE="width: 199"]
<TBODY>[TR="class: grid"]
[TD]Reference
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<TBODY>[TR="class: grid"]
[TD]Facility Performing
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 352"]
<TBODY>[TR="class: grid"]
[TD]Sorted by: Reg/Depot
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<TBODY>[TR="class: grid"]
[TD]Code
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 271"]
<TBODY>[TR="class: grid"]
[TD]Name
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 213"]
<TBODY>[TR="class: grid"]
[TD]Total
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 199"]
<TBODY>[TR="class: grid"]
[TD]IPMCFWCHRPR2
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<TBODY>[TR="class: grid"]
[TD]FWCH
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 352"]
<TBODY>[TR="class: grid"]
[TD]B1
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<TBODY>[TR="class: grid"]
[TD]RPR2
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 271"]
<TBODY>[TR="class: grid"]
[TD]Rapid Plasma Reagin (RPR)
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 213"]
<TBODY>[TR="class: grid"]
[TD="align: right"]9
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 199"]
<TBODY>[TR="class: grid"]
[TD]IPMCFWCHRPR2
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<TBODY>[TR="class: grid"]
[TD]FWCH
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 352"]
<TBODY>[TR="class: grid"]
[TD]B5
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 131"]
<TBODY>[TR="class: grid"]
[TD]RPR2
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 271"]
<TBODY>[TR="class: grid"]
[TD]Rapid Plasma Reagin (RPR)
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 213"]
<TBODY>[TR="class: grid"]
[TD="align: right"]49
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][/TD]
[TD="colspan: 6"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]


The volume right now just shows 9. I want it to display the total of 58.

Can someone assist? Thanks in advance!

 

[Marcílio_Lobão]

Re: Need Help! Vlookup to find a count of identical row matches

FinanceDude2420, Good morning.

You can try to use a SUMIF function.

=SUMIF('Transfer Data'!$A$3:$A$22042,$B1782,'Transfer Data'!$F$3:$F$22042)

Please, tell us if it worked for you.
I hope it helps.

 

[FinanceDude2420]

Re: Need Help! Vlookup to find a count of identical row matches

Thank you for the quick response!

Do I put that within my current formula? If so, where at? I believe I would since I still need to vlookup the reference. Just not sure where to put it in the formula.

 

[Marcílio_Lobão]

Re: Need Help! Vlookup to find a count of identical row matches

FinanceDude2420, Good evening.

I did a little example for you using my suggested formula.
24-08-2016_en_Kioskea_SUMIF_Simulation-OK.xlsx - Speedy Share - upload your files here

Is this what you want?
I hope it helps.