SUMIF ranges linked to a data validation cell
 

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.

SUMIF ranges linked to a data validation cell
 

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.

SUMIF ranges linked to a data validation cell
 

Hi,

Refer to http://www.contextures.com/xlDataval02.html

Challa Prabhu

"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.