Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative to using 10 V-lookup formulas
I have table with sales data.
The user types in the classes they want to sum....they can type up to 10 classes. How can I avoid having to write a formula to sum ten V-lookups? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative to using 10 V-lookup formulas
Well, it would help if you provided some details!
The user types in the classes they want to sum.... they can type up to 10 classes. OK, let's assume that is the range A1:A10 E1:E100 is classes F1:F100 is values to sum =SUMPRODUCT(SUMIF(E1:E100,A1:A10,F1:F100)) -- Biff Microsoft Excel MVP "Tami" wrote in message ... I have table with sales data. The user types in the classes they want to sum....they can type up to 10 classes. How can I avoid having to write a formula to sum ten V-lookups? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative to using 10 V-lookup formulas
Thank you!!! That worked perfectly!
"T. Valko" wrote: Well, it would help if you provided some details! The user types in the classes they want to sum.... they can type up to 10 classes. OK, let's assume that is the range A1:A10 E1:E100 is classes F1:F100 is values to sum =SUMPRODUCT(SUMIF(E1:E100,A1:A10,F1:F100)) -- Biff Microsoft Excel MVP "Tami" wrote in message ... I have table with sales data. The user types in the classes they want to sum....they can type up to 10 classes. How can I avoid having to write a formula to sum ten V-lookups? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative to using 10 V-lookup formulas
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Tami" wrote in message ... Thank you!!! That worked perfectly! "T. Valko" wrote: Well, it would help if you provided some details! The user types in the classes they want to sum.... they can type up to 10 classes. OK, let's assume that is the range A1:A10 E1:E100 is classes F1:F100 is values to sum =SUMPRODUCT(SUMIF(E1:E100,A1:A10,F1:F100)) -- Biff Microsoft Excel MVP "Tami" wrote in message ... I have table with sales data. The user types in the classes they want to sum....they can type up to 10 classes. How can I avoid having to write a formula to sum ten V-lookups? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning an alternative value if lookup cannot be found in array | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
Case specific LOOKUP alternative | Excel Discussion (Misc queries) |