Countifs for a date range

Rahul Bhandari

Hello Team

I need to calculate count of countries within the date range of request received . I am using below formula but its throwing invalid operation error, could u please correct me where I am making mistake.

Current Formula: =COUNTIFS({Table 1 Range 1}, {Table 1 Range 30}, >=[Date Received From]32, {Table 1 Range 30}, <=[Date Received To]32)

Here, {Table 1 Range 1} - Column with Country Names

{Table 1 Range 30} - Date received column

[Date Received From]32 & [Date Received To]32 - Date Range to select

Pleas let me know if you need any further details

Rahul Bhandari

@Paul Newcome , appreciate your quick help :)

Paul Newcome

Try removing the first range.