Count name values on X and Y axis criteria

**ronettes** · 10-08-2019, 05:05 AM

Hi Gurus

Thanks for helping my every time!

I am familiar with the CountIFS function, however I don't get it to work with this scenario.

We have a team of 7 employees who locks up our shop every weekend and opens it again. I need to count how many times each employee opens and closes on the respective weekend days.

There is a tabel at the bottom which I need to summarize the counts.

Fridays we only count the CLOSING, Saturday the person who closed Friday opens Saturday and leaves at 11:00, then the second person works from 11:00 till closing, as well as the whole Sunday.

Thanks

**Richard Buttrey** · 10-08-2019, 05:15 AM

Would you manually complete the expected results since it's possible to interpret this in different ways.

For instance:
Is the summary required for one month or all months?
Are you wanting to count the occasions where an employee both Closes on one day AND opens on the next day - and does this count as 1 or 2 events,
OR count the occasison when an employee EITHER closes or opens on one of the days?

**kvsrinivasamurthy** · 10-08-2019, 09:15 AM

In D43 then copied across.

Please Login or Register  to view this content.

Note the change in heading of Main table Row 2 (TOE,OOP).
Note the change in heading of Days Row 42.

Count name values on X and Y axis criteria

LinkBack

Thread Tools

Rate This Thread

Display

Count name values on X and Y axis criteria

Re: Count name values on X and Y axis criteria

Re: Count name values on X and Y axis criteria

Thread Information

Users Browsing this Thread

Similar Threads

Count unique values with criteria and blanks and an average of maximum consecutive values

[SOLVED] Count number of rows that match criteria and apply values relative to another criteria

[SOLVED] Count values in one list and then narrow/combine values based on criteria and count those

[SOLVED] Count values in one list and then narrow/combine values based on criteria

Changing values of x-axis, and descending order axis(x-axis)

Count values between two criteria

[SOLVED] How to insert X axis scale values next to axis and X axis grid lin

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions