| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vary the Range in a Function
I use this function
=COUNTIF(Sheet2!C$324:C$344;Sheet3!$D5) I am looking for a good way to vary the range C$324:C$344 based on a number I input in anther cell. Lets say in a1 I have the value 20. I would like the range to be C$324:C$344. If I change a1 to 50. I would like the range to be C$294:C$344. Basicaly take the end of the range - C$344 - and subtract the number in a1. Is this possible. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a macro that will select a range that can vary in | Excel Discussion (Misc queries) | |||
| In excel, how do I vary a cell over a data range & see its effect? | Charts and Charting in Excel | |||
| INDIRECT / Setting to vary a range? | Excel Discussion (Misc queries) | |||
| Vary bar colors by bar | Charts and Charting in Excel | |||
| How can I vary graph color by range value | Charts and Charting in Excel | |||
Threaded Mode
