Link to home
Create AccountLog in
Avatar of mcnuttlaw
mcnuttlawFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of mcnuttlaw

ASKER

Works like a charm.  Thank you.