Need help on countifs formula

Options

Hi to everyone!

Appreciate to help me out to figure out why below formula is incorrect arguement?

=COUNTIFS({OPEN PR list Range 9}, [Primary Column]@row, {OPEN PR list Range 13}, <=DATE(2024, 4, 1), {OPEN PR list Range 13}, >=DATE(2024, 4, 30))

If i use no date range it works.

This is how the data file looks like

I wanted to count how many the purchaser has done based on the date range which monthly.

Thank you and awaiting anxiously.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!