setting up formulas to pull data from another sheet.

I have a work book with 2 separate pages in it that i am trying to use to create a controlled document log for health and safety.

The first page (for user entry) has 6 columns:
A is Controlled document number
B is The Event (Accident or Incident)
C is the person who entered it
D is the Type of Event (Cut, Burn or Slip/Trip)
E is the affected individual
F is the Date

On the second page i want it to autocapture information for reporting

I used the "count if" statement to total the number of entries for the year, for accidents and incidents and it worked.

I have 3 other things i want the spreadsheet to calculate and cannot get them to work.

1) i want the spreadsheet to calculate the number of events based on the Event Type. ex. accident & cuts or incident & slip/trip.

tried countif, sum, if(and). They either work for one entry but not another, or dont work at all

2)i want it to break down the results per calandar quarter.

tried countif (greater than or equal to one date),[less than the other date] - but this didnt work I also tried inputting the number into another column and using this value but still won't work

cannot use countifs statement - not loaded and cannot get in excel

any suggestions would relieve temporary baldness as i am pulling out my hair with this one.

Hi
Use count(if( function

For example in C7 for first quarter for accidents use this copied down

Please Login or Register  to view this content.

Regards

Hi

Sorry I forget to mention two things

1. Check that events in both sheets like cut, burn are exactly same (check
for spaces at
the end or at the start.

2. This is an array formula after copying press F2 (for edit mode) hold down
Ctrl and Alt key and then press enter key. {} should appear arround
the formula. Then copied down

See attached sheet also

Regards

I think This is working for you.