countif(Range,criteria) question

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
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:
 
Back
Top