Generate daily report from different columns

[dita]

Hello!




I have a very simple Excel file which have 5 columns with different data. It´s attached as reference.


I wonder if it is possible to get some info based on column "DATE IN" or "DAY OFF".


The information that I want to get together in one click is the following:


1. Total number of READERS per day. So if Claire appears twice, it should be counted as one only.


2. The total number of BOOKS per day. No matter if Claire appears twice, it should be counted as two.


3. The total number of PAGES per day.


Ideally, it should be provided with a pop-up message. If it is not possible, it can be generated in another Sheet.


Also, I want to get some kind of alert when the number of PAGES per day exceeds 600 pages. I think that a pop-up message would be useful too.


Finally, in the tab "mailgroup", there are a couple of emails, so if the results can be sent to them, that would be fantastic.


Would this be possible?


Many thanks in advance and sorry if I am asking too much!