| 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") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range values in a function
=COUNTIF(INDIRECT("E"&A1&":"&"E"&B1),"*bob")
-- Gary''s Student - gsnu200777 "Developing Rang Values for Functions" wrote: 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") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range values in a function
Try this:
=COUNTIF(INDIRECT(D10),"*bob") HTH, Paul -- "Developing Rang Values for Functions" <Developing Rang Values for wrote in message ... 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") |
| Reply |
| 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) | |||
Linear Mode
