countif(Range,criteria) question

[David]

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

 

[joel]

Use offset function like this


=COUNTIF(OFFSET($A$1,0,1,1,6),">0")

The offset parameters are as follows

Offset(Rows offset, column Offset, Number of Rows, Numbeer of columns)


I put the formula into A1 and the function uses a range starting on
column to the right of A1 with a size of 1 row and 6 columns

 

[Stefi]

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: