How to count the number of jobs based on multiple conditions?

[jkevz07]

Hi! in excel I used the formula Countif. In the appsheet, I used the expression of Count and Select but its not working. Can you help me with my code below, the expression is fine but it's not counting based on the given data in the form.

COUNT(SELECT(Customer Log Sheet[Status], AND([Status] = [_THISROW].[Required Job],[Date & Time (Started)] = [Date (From)],[Date & Time (Ended)]=[Date (To)])))

[jkevz07]

I found the solution already! Thanks!

COUNT(SELECT(Customer Log Sheet[Status], AND([Status] = [_THISROW].[Required Job],[Date & Time (Started)] >= [Date (From)],[Date & Time (Ended)]<=[Date (To)])))