Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Usage questions
Message
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Miscellaneous
Thread ID:
00374738
Message ID:
00376915
Views:
21
>I've looked in Excel help, but could not find the
>answers to the following:
>
>1. If I enter a date on sheet1 A10 how do I get
>that date to automatically appear on sheet2 B12?

formula on sheet2
=sheet1!A10

>
>2. I have columns with totals...
>
> A12 = sum(a3;a11)
> A24 = sum(a13;a23)
> etc.
>
>I have 60 totals.
>Now I need a GRAND Total.
>Is there a way to do this other than including
>each total (A12,A24,A36 to A5##) in a series
>of sum commands?

Looks like there is no way around it, unless you NAME your cells, and then you still must reference sum of names.
Edgar L. Bolton, B.S. B.B.A.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform