ExcelBanter - Countif & Offsets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Countif & Offsets (https://www.excelbanter.com/excel-discussion-misc-queries/176883-countif-offsets.html)

Yuanhang

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?

Yuanhang

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?

All times are GMT +1. The time now is 01:22 PM.