use SUMPRODUCT instead:

SUMPRODUCT(--(A1:A100=<g/l code),B1:B100)


See

http://www.mcgimpsey.com/excel/doubleneg.htm


for an explanation of the "--"

In article ,
"Need Help With Vlookup" <Need Help With
wrote:

I need vlookup to capture and sum all figures pertaining to the same G/L code
even if there is more than one of the same line item on the data sheet. The
data sheet is separate from the summary sheet which is where I am pulling the
information onto.