SUMIF ranges linked to a data validation cell

S

Steggles

How do you link the ranges in a SUMIF formula to a another reference cell.
The reference cell would be set up as a data validation list. Your help
would be much appreciated.
 
P

Pete_UK

I think you will be looking to use the INDIRECT function, but you will
need to give more details of your problem if you want a more specific
answer.

Hope this helps.

Pete
 
Top