Help with formula to count with dates data.

[Fred Wayne]

I have a Book called 1232, it has 3 sheets("123", "Teste March Sent Emails", and "Teste March Received Emails"). In "Teste March Sent Emails Sheet", I have values entered by date with the time included in Column A. In Column B, I have the days of March in consecutive order from March 1st to March 31st. In Column C, I need to count the quantity of how many on March 1st, March 2nd, March 3rd, and so on forth until March 31st. Can it be possible?

Thank you in advance!

 

[AlanSidman]

In E2, type =COUNTIF($B$2:$B$3331,D2) and copy down

 

[Fred Wayne]

It worked! Thank you so much.

 

[Fred Wayne]

In the sheet called "123", I have de same dates (from March 1st to March 31st), however, The dates have the time. I need that Column C(C4:C34) to display the Quantity of messages sent in March 1st at 7:00AM or between 7:00 Am and 8:00AM and so on forth. Could the same principle of the "IFCOUNT" formula be applied to find out how many messages were sent in March 1st at 700AM, at 8:00AM, 9:00AM and so on forth?

 

[AlanSidman]

You will need to use the Countifs function. https://www.get-digital-help.com/count-entries-between-date-and-time-criteria-in-excel/

 

[Fred Wayne]

Ok. I'll give a try to this link: 'https://www.get-digital-help.com/count-entries-between-date-and-time-criteria-in-excel/. I'll see if it works. Well, thank you anyway. If it don't work I'll try somewhere else. Thank you so much.

 

[p45cal]

This can be done with a pivot table in less than one minute. See attached.

 

[Fred Wayne]

For God´s sake. It looks great! But what range did you choose? I have almost more than one hour trying to simulate your result, however, it has been hard for me! That is why I am requesting a formula to get the same result.

 

[p45cal]

Trying to link to a 45 second video:

2022-04-11 12-15-25.mkv | Powered by Box

app.box.com

This is an .mkv video file, if you can't get to see it I'll try to convert it into a file format suitable for you (but you need to tell me what that format is).

 

[Fred Wayne]

For God's Sake. I could have done it. It is really sooo easy, Thank you so much for sending me the short video. I learned a lot. Thank you so much.

 

[lopezmason]

It's great in here. There are so many things about excel I don't know yet. You guys are too good. Thank you so much for your help

 

[Fred Wayne]

This is the right place for you to ask for help and learn. They all are simply amazing.