Request for help - COUNTIFS Formula

Requesting some assistance with a COUNTIFS formula. I want to count the number of instances within a date column titled 'ACTUAL FINISH' between 1/1/23 and 3/31/23 to display a quarterly total count for Q1 using the Sheet Summary feature.

For example, there are numerous dates between 7/13/22 - 3/31/23 in my image however only '2' fall within the result range I need therefore the Sheet Summary should show the number '2' if my formula is working correctly but alas it is not.

=COUNTIFS[(ACTUAL FINSIH)] AND([DATE (ACTUAL FINISH) is between (2023,1,1:2023,3,31)


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!