Vlookup sums

[Doctorbob]

I am building a allocation spreadsheet that tracks allocation balance b
purchase and / or sales contract number. I was wondering if you ca
vlookup a spreadsheet and get the sum of a certain contract number tha
has mutiple deliveries

 

[Andy B]

Hi

You would probably need to use SUMPRODUCT to return this info. Maybe
something like:
=SUMPRODUCT((A2:A1000="contract number")*(B2:B1000))
where your contract number is in A2:A1000 and your values are in B2:B1000
With SUMPRODUCT, the ranges cannot be full column references (A:A) and must
be the same size.