| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range values in a function
Given: A1 = 2, B1 = 6
I can create the a Range value in cell D10 by ="E"&A1&":"&"E"&B1 which D10 will show E2:E6 Cells A1 and B1 are calculated, allowing the range to be updated What I need is place the range created in D10 in to a function As, COUNTIF(E2:E6,"*bob") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a range of values in a range of cells | Excel Worksheet Functions | |||
| Looking for a function to count alpha values in a range. | Excel Worksheet Functions | |||
| Use criteria for values in range for small function | Excel Worksheet Functions | |||
| Selecting a range of values for another function | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
