View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tami Tami is offline
external usenet poster
 
Posts: 123
Default 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?