help counting between sheets

neit

New Member
Hi
I have a work book with 7 worksheets and 1 summary sheet
each work has 3 columns name, late (Y,N), more 15mins(Y,N).

I am trying to count the many times an employees name appears in the
name column over all 7 sheets and ad them to gather in the summary
column against the employees name. eg: if employee 1 is late on day1, day3 and day4 the formula should tcount 3 next to the agents name in the summary sheet tp indicate that the employee was late 3 times in over a week.

next out of those 3 late time I would like to create another formula that will tell me how many times that employee was more that 15mins late.

At the moment I am have only been able to count between sheets using
the counta function but this counts all fields, but I am trying to only count using an employees name as the criteria. So for example in the summary sheet. I enter joe blogs in the A3 (name) I would like the formula in B3 (number of lates) to count the number of times that thats employees name appears on each sheet. Then in C3 (number lates more that 15mins) I would like that formula to count out of the lates how many time the employee was late more than 15mins.

Is this possible?
any help would be great

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying

debooo

Board Regular
im not exactly sure what you mean, but i would think you would be able to do it using either the sumif or the countif functions. im leaning more towards the countif. but im not sure since i cannot see the sheets

MrExcel MVP
Hi - welcome to the board.

"I have a work book with 7 worksheets and 1 summary sheet "

You probably shouldn't. If, for example, this is 7 sheets, one for each day of the week, then you should have one sheet, with an extra column to record the date. You can then use excel's functions as they were intended, rather than having to jump through hoops to get there.

Too late to change the sheet set-up?

neit

New Member
I will see what happens when merge the sheets to one.

Thanks for the replies.

neit

New Member
Thankyou for you help putting all the data in one sheet has enabled me
to get the desired results I was after.

Thankyou for the suggestion

Replies
7
Views
2K
Replies
10
Views
3K
Replies
1
Views
198
Replies
4
Views
282
Replies
3
Views
226

1,190,616
Messages
5,981,956
Members
439,745
Latest member
VBANewbieJohn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back