Formula to first find and then sum

[Chris Mcarthur]

I have a workbook with tabs 1 - 31 representing the days of the month.
On each sheet we have employees name, ID, start time, date, and Comments. I currently have a Summary sheet that pulls over the ID and Comment, if any.

What I now need is something to total, if a person (ID) has a comment, how many comments include the word - "sick", how many are "early" and how many do they have that include the word "late".

so for example: ID 542 has 4 early, 2 late, 0 sick ( for the month of February)

 

[Chris Mcarthur]

Ok where am I placing the the Count if formula? on the end tab -( Summary) and have ID/early/late/ sick tally totals?

 

[mikerickson]

I was demonstrating a feature of COUNTIFS.
Where to use that feature,... your project sounds too big to give a detailed answer on this forum.

 

[RasGhul]

Hi Chris,


The main problem is your data is spread-out over multiple sheets rather than a list of dates for February on the same sheet. This means we need to reference all of your sheets to calculate Feb.

Its much easier to extract data from one sheet then multiples.

 

[Chris Mcarthur]

Ok thanks for your help