Have 2 worksheets work together

  • Thread starter Thread starter Gardengramma
  • Start date Start date
G

Gardengramma

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!
 
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:A20<>"")*(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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top