Countifs for a date range

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!