Counting Events in Excel

[msstori]

Hello, a workbook full of a report that is pulled daily. The report tells me each phone stats for employees. So each day I know how long their phone was in a certain phone state. What I would like to do is add a MTD tab with a formula that will give me the person's name and count how many times they appear on a daily tab with phone state times higher than a certain percentage.

The daily tab contains both raw data on the time and the percentage.

Can this be done? and if so how?

Thank you in advance

[JBeaucaire]

COUNTIFS()
SUMIFS()
Pivot Tables

Attach a sample workbook with just enough data to demonstrate your need. Make sure your desired results are mocked up as well, manually calculated for now.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Tony Valko]

Can you post a SMALL sample file and show us what result you expect?

A SMALL file will have about 20 rows worth of data.

[msstori]

Did I attach it correctly?

[JeteMc]

This solution makes use of some helpers. The tabs (sheets) to be 'counted' are listed in column P and the 'limit setters' are in R2 (>) and S2 (3%). The formula, which could be pasted in row 4 and copied down is:

Please Login or Register  to view this content.

Note that the range of sheets has been put in a table (Table1[Sheets]) so that the formula will update as new sheets are added to the list using the tab key.
Note: this assumes consistent formatting of the daily tabs.
Let me know if you have any questions.