Have 2 worksheets work together

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!
 
S

Sandy Mann

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incone & Expenses Statement 0
Counting multiple occcurrences between date range 3
summaries on alternative sheets 6
Why can't I use the MONTH function within the SUMIFS statement? 5
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Highlighting multiple triggers 4
Working out VAT owed 1
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0

Top