ExcelBanter - Alternative to using 10 V-lookup formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Alternative to using 10 V-lookup formulas (https://www.excelbanter.com/excel-worksheet-functions/227937-alternative-using-10-v-lookup-formulas.html)

Tami

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?

T. Valko

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?

Tami

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?

T. Valko

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?

All times are GMT +1. The time now is 09:08 AM.