=COUNT(IF(A1:I89<{2921,23344},A1:I89))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ceej" wrote in message
...
FYI ... my data has 89 rows x 9 columns, with the criteria being in column
G.
I tried the formula and the results were the exact number of rows, 89. I
double-checked the data, and it is numberic. Any other suggestions??
--
Thank you ... ceej


"VBA Noob" wrote:


=sumproduct(--(a1:a7<2921)*(--(a1:a7<3344)))


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread:
http://www.excelforum.com/showthread...hreadid=562254