| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif & Offsets
My formula is like that as followed:
=COUNTIF(OFFSET(AF:AF, 11,0,128,1),"TRUE") And I got a result as "0". Then I evaluate the formula, it showed "Countif($AF$12:$AF$139, "TRUE") ". This is exactly what I want. Then I tried to type "Countif($AF$12:$AF$139, "TRUE")" into a cell, it came up with the right answer. So I don't know what I did wrong in the original formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorry, I figured it out. Thank you.
"Yuanhang" wrote: My formula is like that as followed: =COUNTIF(OFFSET(AF:AF, 11,0,128,1),"TRUE") And I got a result as "0". Then I evaluate the formula, it showed "Countif($AF$12:$AF$139, "TRUE") ". This is exactly what I want. Then I tried to type "Countif($AF$12:$AF$139, "TRUE")" into a cell, it came up with the right answer. So I don't know what I did wrong in the original formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "internal margin" and axis offsets (excel 2007) | Charts and Charting in Excel | |||
| Image (object) offsets in Web show mode | Excel Worksheet Functions | |||
| Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| average, array and offsets | Excel Worksheet Functions | |||
Linear Mode
