I have a formula:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(Sheet1!N:N,ROW(Sheet 1!N2:N65536)
-ROW(Sheet1!N1),0,1)),--(Sheet1!N2:N65536="Dog"))
Calculating the sheet takes forever because of the cell range.
Sometime the sheet will have 10 rows other times it will have 10,000
rows, so I put the range N2:N65536. I already have a count of the
number of rows in a cell. Can I refer to that cell in the range, for
example: N2:N&B1 (where B1 has the number of rows)?
I tried it a ton of ways but can't get it to work. Any input would be
appreciated.
--
KMartin
------------------------------------------------------------------------
KMartin's Profile:
http://www.excelforum.com/member.php...o&userid=37164
View this thread:
http://www.excelforum.com/showthread...hreadid=568826