countifs between two dates not working, i.e. returning the right number

Options

=COUNTIFS({Case Consultation Tracker Submission Date}, >=DATE(2024, 1, 1), {Case Consultation Tracker Submission Date}, <=DATE(2024, 1, 31), {Case Consultation Tracker Range Status}, <>"NOT Case"), returns 34. The right number determined by filtering the data is 41.

All the numbers returned are incorrect! Help!

Tags:

Answers

  • lisalettieri
    Options

    =IF(COUNTIFS({Case Consultation Tracker Submission Date3}, >=DATE(2024, 7, 1), {Case Consultation Tracker Submission Date3}, <=DATE(2024, 7, 31)), COUNTIFS({Case Consultation Tracker Submission Date3}, <>0))

    Above is returning blank when there is no data but when applied to dates where there is data to count, I get #INVALID DATA TYPE. Sorry if I said this before.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!