If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
combining functions (VLOOKUP and SUM)
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 |
#2
|
|||
|
|||
combining functions (VLOOKUP and SUM)
Hi
use SUMIF for this. e.g. =SUMIF(A1:A100,"a",C1:C100) to sum column c if column A conatins an 'a' -- Regards Frank Kabel Frankfurt, Germany wrote: 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 |
Thread Tools | |
Display Modes | |
|
|