Alternative to using 10 V-lookup formulas

T

Tami

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

Tami

Thank you!!! That worked perfectly!

T. Valko said:
Well, it would help if you provided some details!


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))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where to buy alternative themes for Word 2013? 0
Changing Source Data using V-lookup 2
How to paste this down? 3
adding multiple values from matched search results 3
Multiple Columns in Sum Range using SUMIFS 1
Importing etc. 1
lookup values from certain text file. 0
Getpivotdata....showing filter 0

Top