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.

Reference <TBODY> </TBODY> Facility Performing <TBODY> </TBODY> Sorted by: Reg/Depot <TBODY> </TBODY> Code <TBODY> </TBODY> Name <TBODY> </TBODY> Total <TBODY> </TBODY> IPMCFWCHRPR2 <TBODY> </TBODY> FWCH <TBODY> </TBODY> B1 <TBODY> </TBODY> RPR2 <TBODY> </TBODY> Rapid Plasma Reagin (RPR) <TBODY> </TBODY> 9 <TBODY> </TBODY> IPMCFWCHRPR2 <TBODY> </TBODY> FWCH <TBODY> </TBODY> B5 <TBODY> </TBODY> RPR2 <TBODY> </TBODY> Rapid Plasma Reagin (RPR) <TBODY> </TBODY> 49 <TBODY> </TBODY> <TBODY> </TBODY>

<TBODY>
</TBODY>

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.