yeedao Wrote:
1. if I need to count numbers greater than 1.2, shall I change the
fomular into below?
"=MATCH(TRUE,SUBTOTAL(9,OFFSET(A1,0,COLUMN(A1: T1)-COLUMN(A1)))<1.2,0)-1"

Yes.

2. What do you guys mean by "...confirmed with CONTROL+SHIFT+ENTER"?

After typing the formula, instead of hitting just the ENTER, press the
CONTROL and SHIFT keys down, then while holding them down, hit the
ENTER key. Excel will place braces around the formula which will
indicate that you've entered the formula correctly.


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=395619