| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif(Range,criteria) question
For 'Range' i would like the intersect of the row in which the function
resides and the adjacent, named 6 x 6 range. I,ve tried =Countif(MyRng Row(), MyCrit) but no joy Please advise, Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif(Range,criteria) question
Maybe this:
=COUNTIF(OFFSET(adj,ROW()-ROW(adj),0,1),"a") where adj is the name of the adjacent range, "a" is the criterium -- Regards! Stefi €žDavid€ť ezt Ă*rta: For 'Range' i would like the intersect of the row in which the function resides and the adjacent, named 6 x 6 range. I,ve tried =Countif(MyRng Row(), MyCrit) but no joy Please advise, Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif with a Range of criteria | Excel Worksheet Functions | |||
| countif, range and criteria | Excel Discussion (Misc queries) | |||
| Countif with date range criteria | Excel Worksheet Functions | |||
| Multiple criteria/Countif question | Excel Discussion (Misc queries) | |||
| SUM(COUNTIF(range,NOT Criteria)) | Excel Worksheet Functions | |||
Hybrid Mode
