combining functions (VLOOKUP and SUM)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel report that needs to be fed from an excel
database. The best function I found was vlookup. However,
vlookup only capture the result of one reference (first
or last depending on the last argument). Is there a way
to tell the function vlookup to sum all results of a same
criteria before referencing it back to my report.

Here is an example:
June Monthly Result Database

Products Total Sales Qtty Products
Sales Qtty
a a 2
c a 3
f b 5
c 1
c 4
c 8
d 3
e 1
f 3
 
Hi
use SUMIF for this. e.g.
=SUMIF(A1:A100,"a",C1:C100)
to sum column c if column A conatins an 'a'
 
Back
Top