Opps - Forgot a critical part!!

T

Tim

Sorry, I noticed I left out the data! Worksheet 1 contains accident information. I have columns for each type of accident (i.e Cut/Bruise.) The summary sheet (Worksheet 2) should total the number of accidents by type of accident by month and building. For example:
Building Date Lifting / Strains Cuts / Bruises Trip / Fall
Building 1 1/25/04 0 1
Building 2 1/30/04 1 0
Building 3 2/15/04 0 1

So, for my summary sheet I want the total injurites in Building 1 from Lifting/Strains for Jan, etc..

Thanks for the help in advance

-Ti
 

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

Counting multiple occcurrences between date range 3
Summary using sumif 9
Merging Qry into Table 2
formula patterns with a gap of two 0
Will not give accurate totals. 3
Add numbers with a DATE as one of the conditions 5
Macro for Copying pasting between different spreadsheets 4
AURO SUMMING FROM TABLE AND COPYING TO NEW WORKSHEET 0

Top