Are the entries in column J really text?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"sarge355" wrote:

I have a general ledger spreadsheet with a annual and monthly tab followed by
the individual account tabs. On the monthly tab I have the following formula:

=SUMIF('9000-Muck Site'!$J:$J,"="&(TEXT(I$5,"mmm-yy")),'9000-Muck Site'!$D:$D)

My problem is the range is not picking up all of the rows. Based on the
formula above it stopped at D96. How do I extend (or show) other rows past
D96?

Thanks!