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

lisalettieri

=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!

lisalettieri

=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.