Alternative to using 10 V-lookup formulas

  • Thread starter Thread starter Tami
  • Start date Start date
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?
 
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...
 
Back
Top