|
| 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
April 16th, 2009, 07:29 PM
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
April 16th, 2009, 07:39 PM
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
April 16th, 2009, 09:29 PM
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
April 16th, 2009, 10:00 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
