Posted to microsoft.public.excel.newusers

sarge355

external usenet poster

Posts: 3

Formula Question...

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula question	Heather	Excel Discussion (Misc queries)	1	October 16th 06 04:23 PM
Formula Question	Confused Excel User	Excel Worksheet Functions	0	October 13th 06 03:55 PM
Newbie Question - Subtraction Formula Question	[email protected]	Excel Discussion (Misc queries)	3	May 5th 06 05:50 PM
Formula Question	Formula Question	Excel Discussion (Misc queries)	2	April 23rd 06 12:00 AM
Formula Question	Qaspec	Excel Discussion (Misc queries)	2	January 10th 05 03:59 AM

All times are GMT +1. The time now is 08:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us