Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - How to Sum Multiple Cells
=IF(ISERROR(VLOOKUP(M2,Activities_Closed!K$2:M$430 8,3,FALSE)), "0",
VLOOKUP(M2,Activities_Closed!K$2:M$4308,3,FALSE)) Hello!!! =) Above is what I currently have for the formula used to locate information on another worksheet inside the workbook. It is looking for matching ticket numbers and displaying the corresponding minutes. My question is: There are several tickets with several numbers. How do I get excel to find not just the first ticket, but all of the tickets and sum the minutes? Thanks! I've searched everywhere and have turned up nothing, hopefully this is possible! :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - How to Sum Multiple Cells
Try
=SUMPRODUCT((Activities_Closed!K2:K4308=M2)*(Activ ities_Closed!M2:M4308)) Mike "April" wrote: =IF(ISERROR(VLOOKUP(M2,Activities_Closed!K$2:M$430 8,3,FALSE)), "0", VLOOKUP(M2,Activities_Closed!K$2:M$4308,3,FALSE)) Hello!!! =) Above is what I currently have for the formula used to locate information on another worksheet inside the workbook. It is looking for matching ticket numbers and displaying the corresponding minutes. My question is: There are several tickets with several numbers. How do I get excel to find not just the first ticket, but all of the tickets and sum the minutes? Thanks! I've searched everywhere and have turned up nothing, hopefully this is possible! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup, multiple results (in different cells)? | Excel Worksheet Functions | |||
connecting multiple cells to new sheet (VLOOKUP?IF?) | Excel Worksheet Functions | |||
Vlookup on multiple cells | Excel Worksheet Functions | |||
How can I create a VLOOKUP that pertains to multiple cells? | Excel Discussion (Misc queries) | |||
VLOOKUP - Multiple cells in lookup value | Excel Worksheet Functions |