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

On May 15, 11:44 am, Steggles
wrote:
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.