I constructed a set of XL2000 worksheets to record my household utility
bills. They're named Power, Gas, Water, Sewage, and Garbage Pickup (GP).

Recently, I added another worksheet named Summary, and inserted the
function=SUM(Power:GP!B4) into the corresponding cell beginning. It worked
beautifully.

However, when I tried to apply the same function to an older (but still
XL2000) set of worksheets, it returns NAME?

The 'older' set of worksheets contains monthly charges from 1992 to 2006.

The 'newer' set of sheets contains monthly charges for just one year, 2006.

I think I may see what the problem is--just don't know "how" to enter the
correct formula syntax. Here's what I think the problem is:
the new set of data is for only one year, whereas the old set covers from
1992 to 2006--a range of numbers. Perhaps a different formula must be
entered. (?)

For that set, it appears that I must enter a formula that does two
operations at once.
1.) Summarize the numbers in a range within a worksheet; 2.) Summarize the
worksheets.

I'm lost here ... would appreciate any constructive comments!

Thanks!