Count of Requests/Emails Per Day

bbloch18

I am able to calculate today number of requests and total number of emails.

I want to be able to calculate requests per day and emails per day.

What is best function to use?

J. Craig Williams

Maybe COUNTIFS

Craig

bbloch18

Thanks Craig.  I tried that formula and cant' seem to get it to work.

Thanks,

Barb

J. Craig Williams

This would show the number of times that [Request Date] matches the date in the same row.

=COUNTIFS([Request Date]:[Request Date], [Request Date]@row)

This would show the number of emails per day

=SUMIFS(Emails:Emails, [Request Date]:[Request Date], [Request Date]@row)

I would use this in a header section, not on each row, but either works and has use cases. If I want to reuse the [Request Date] in my header, I would also check if the Brief Desciption column was blank, so I didn't count the header section by mistake

=COUNTIFS([Request Date]:[Request Date], [Request Date]@row, [Brief Description of Request]:[Brief Description of Request], NOT(ISBLANK(@cell)))

=SUMIFS(Emails:Emails, [Request Date]:[Request Date], [Request Date]@row, [Brief Description of Request]:[Brief Description of Request], NOT(ISBLANK(@cell)))

I hope that helps.

Craig