Formula to count (in a whole number ie 1,2,3) from 1 column, based on another column

[texhater]

So, my sheet has a row that gets populated every time an item is used. The user must enter the 'date used', 'duration of time checked out' and other categories that aren't important.

What I'm wondering is, in a different cell corresponding with each month of the year, can I get a count (in a whole number ie 1,2,3) when someone enters a 'duration'?

For example, someone goes to check out a truck. They enter 1 Jan in the 'date used' column. Then they enter 2.5 hours in the 'duration of time checked out' column. In another cell corresponding to the month of Jan, can I have it return a count
for each time someone entered a 'duration' time. I don't need the total hours counted, I've already done this in another cell. What I need is to get a count every time someone enters a 'duration' in there. The next time someone enters another line item, and enters a 'duration', that number would go to "2" and so on.

I need this because there will be multiple individuals checking out trucks at different times, and I am trying to keep track of how many times employee 1 checks out the truck in the month of Jan, or Feb or any month, along with employee 2, or 3...each employee has their own column and would put the 'duration' in their applicable column, and the total count would go against them in that other cell according to what month they entered in 'date used'.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

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

[texhater]

excel is attached

[JeteMc]

Utilizing the present layout try the following.
1) Paste the following formula into cell D508: =SUMPRODUCT((MONTH($C7:$C500)=1)*(ISNUMBER(E7:E500)))
2) Drag the fill handle over to cell F508
3) Copy the formula that is in cell D508 from the formula bar and paste the formula into cell G508, then change the 1 to a 2 i.e. =SUMPRODUCT((MONTH($C7:$C500)=2)*(ISNUMBER(E7:E500)))
4) Drag the fill handle over to cell I508
5) Repeat this procedure for each month.
Let us know if you have any questions.