Search for values in disparate columns

I need to sum values located in random, disparate columns.  The column locations are random and defined in another cell.

The attached spreadsheet better shows what I am trying to accomplish.
Book1.xlsx
LVL 2
mcnuttlawAsked:
Who is Participating?
 
dlmilleConnect With a Mentor Commented:
See attached.

Dave
book1-r1.xlsx
0
 
mcnuttlawAuthor Commented:
Works like a charm.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.