| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Have 2 worksheets work together
Beginner user in Excel. I have 2 worksheets, one is detail, the other is
summary for the months. I am trying to use a formula in the summary worksheet that will correspond with the detailed one to move the monthly totals into the summary worksheet. I don't know how to do this. HELP! -- Gardengramma |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Have 2 worksheets work together
With:
Summary sheet is Sheet2, Detail Sheet is Sheet1 In Detail Sheet the dates are in Column A, the amounts are in Column B Formula for thr above: =SUMPRODUCT((MONTH(Sheet1!A1:A20)=1)*(Sheet1!A1:A2 0<"")*(Sheet1!B1:B20)) Change the Sheet names and ranges to suit your needs. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Gardengramma" wrote in message ... Beginner user in Excel. I have 2 worksheets, one is detail, the other is summary for the months. I am trying to use a formula in the summary worksheet that will correspond with the detailed one to move the monthly totals into the summary worksheet. I don't know how to do this. HELP! -- Gardengramma |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I Tie Worksheets to one Work book? | Excel Worksheet Functions | |||
| Copy worksheet into several worksheets in the same or another work | New Users to Excel | |||
| Macro to work only on selected worksheets | Excel Discussion (Misc queries) | |||
| UDF doesn't work in old worksheets | Excel Discussion (Misc queries) | |||
| List of Worksheets in a work book | Excel Worksheet Functions | |||
Linear Mode
