| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Ranges
Try this:
=COUNTIF(INDIRECT("J"&B2&":J"&A2),"Yes")/COUNTA(INDIRECT("J"&B2&":J"&A2))*100 HTH, Elkar "Graham" wrote: Hi, Following previous advice, the following formula returns the % "Yes" in a range from J84:J**; ** being referenced from a value in cell A2. Is it possible to now tweek this formula so that the first part of the range (J84)is also remotely referenced from a value in say B2 ? i.e. J"&B2:J"&A2 ? =COUNTIF(INDIRECT("J84:J"&A2),"Yes")/COUNTA(INDIRECT("J84:J"&A2))*100 Many Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamic Ranges
Many thanks to you both!
"Elkar" wrote: Try this: =COUNTIF(INDIRECT("J"&B2&":J"&A2),"Yes")/COUNTA(INDIRECT("J"&B2&":J"&A2))*100 HTH, Elkar "Graham" wrote: Hi, Following previous advice, the following formula returns the % "Yes" in a range from J84:J**; ** being referenced from a value in cell A2. Is it possible to now tweek this formula so that the first part of the range (J84)is also remotely referenced from a value in say B2 ? i.e. J"&B2:J"&A2 ? =COUNTIF(INDIRECT("J84:J"&A2),"Yes")/COUNTA(INDIRECT("J84:J"&A2))*100 Many Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Ranges | Excel Discussion (Misc queries) | |||
| Dynamic ranges | Charts and Charting in Excel | |||
| Dynamic Ranges | Excel Discussion (Misc queries) | |||
| dynamic ranges | Excel Worksheet Functions | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Hybrid Mode
