Working with 3-D functions across worksheelts

[Guest]

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?

Any ideas of why this function worked in one set and failed in the other?

 

[Guest]

Sorry for the delay in response, Elkar. To answer your second question, no,
the sheet names are not the same--see my first post--and each sheet has a
single name, i.e., no spaces.

However, I think that I may see what the problem is--just don't know "how"
to enter the correct formula syntax. Here's what 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.

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.

WAGg