Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Usage questions
Message
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Titre:
Divers
Thread ID:
00374738
Message ID:
00380491
Vues:
20
thanks

>>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.
Glenn
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform