| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
| Data validation: concatenate two separate ranges in the List? | Excel Discussion (Misc queries) | |||
| Data Validation list linked value | Excel Discussion (Misc queries) | |||
| Data validation using multiple ranges | Excel Discussion (Misc queries) | |||
| Data Validation linked to cell Formula | Excel Discussion (Misc queries) | |||
Linear Mode
