Vlookup sums

  • Thread starter Thread starter Doctorbob
  • Start date Start date
D

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
 
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.
 
Back
Top