Dave, Good idea. I think I'll do the same.

Does anyone want to know what I have learned today?

Bob U. mentioned that Mike Alexander was one of the presenters. I found out from his web site the function that was used to calculate age. I have always liked DATEDIF but Mike used one function that I didn't even know exists.

DAYS360( ) <--- I haven't come across this function on this board.

=IF(D8="","",DAYS360(D8,D2)/360) (Formatnumber decimal places = 0)

D8 = date of birth D2 = today's date.

DAYS360 is based on a 30-day month for 12 months and leap year February is within 30 days.

Any comments on DAYS360( )?

Epinn

"Dave Peterson" wrote in message ...
I don't. But I know many like to.

If I hide those sheets, then it gets less obvious what's happening. I will lock
all the cells and protect the sheet, though. I don't want someone (me!)
changing a cell that affects my results.

Epinn wrote:

Yes, totally agree. I only learned about this a couple of days ago. Do you usually hide the dummy sheets?

Thank you for sharing.

Epinn

"Dave Peterson" wrote in message ...
This type of "sandwich" can be useful.

I like to have two worksheets named Start and End surrounding the worksheets
that I want to add (say).

Then I can do:
=sum(start:end!a1)

And I can move worksheets into that sandwich or move worksheets out of the
sandwich. It makes playing what-if games pretty nice.

Epinn wrote:

Yes, I was aware of the logic behind the "wrong" result before I posted.

When we drag down a cell containing a formula, the relative address is changed.

I think this is different and there is no way that Excel knows how to readjust. ;)

Next time, I'll say it is not the result that I have expected but .......

Epinn

"Dave Peterson" wrote in message ...
After you hit enter, excel expanded this:
=SUM('*'!A1)
to:
=SUM(Sheet1:Sheet2!A1,Sheet3!A1)

After you drag sheet3 after sheet1, your formula is still:
=SUM(Sheet1:Sheet2!A1,Sheet3!A1)

Which means to add all the values in A1 in all the sheets between sheet1 and
sheet2 (including sheet3 since in that "sandwich" of sheets), then add Sheet3's
A1 one more time.

It may not be what you expect, but the formula evaluates to the correct (but not
your intended) sum.

It's not too unlike this in B1:
=sum(a1:a5,a3)

It adds up just fine, but it may not be what you wanted.

Epinn wrote:
<<snipped
It is pretty smart that it adds up A1 in Sheet1,Sheet2 and Sheet3 even though they are not in sequence/contiguous. I get the correct result. Then I drag Sheet3 to after Sheet1 and end up with Sheet1,Sheet3,Sheet2 and Sheet4. Check the result again on Sheet4.

Wrong!
<<snipped
--

Dave Peterson

--

Dave Peterson

--

Dave Peterson