Trouble with Excel 2000 not calculating/performing formulas

[Guest]

I have the following formula in an Excel spreadsheet:

=SUMIF('Placement List - Done'!$M$3:$M$1301,A13,'Placement List -
Done'!$L$3:$L$1301)

The A13 reference is a person's name; the data is basic sales information.

I have been using a series of linked spreadsheets as a make-shift reporting
database for 3 years. Up until today, it worked fine. This particular
formula does not go outside of the Workbook - just between sheets in the same
workbook.

Suddenly, it will not bring back any data! F9; re-entering formula;
re-formatting source data - none of this has helped.

Any suggestions?

Brian

 

[Guest]

Brian,
Load the saved copy. I'm just kidding.
Use the desktop search to find the previous version. Really.

Save current copy of sheet with new name.
Possible that rows or columns were inserted. The hard coded cell references
do not change on column and row inserts.
Make sure m3 to m1301 contain data
Make sure l3 to l1301 contain data
Make sure A13 contains data
Make sure A13 is an exact match to something in the M column? Create some
test data if you have to like "A" in A13 and "A" in M13 so you can prove it
does work.

search msdn.microsoft.com for sumif

All else fails
Save workbook with new name.
For each sheet in the workbook select everything on sheet copy and paste to
new workbook. You'll have to rename the new workbook sheets. Maybe
something got corrupted somewhere on the inside.

Good Luck
Dan