Forum Discussion

davidmansour's avatar
davidmansour
Copper Contributor
Mar 04, 2025

Count occurances of a number in range within after a certain date

Hello,

 

I have a table with Dates in Column A and Drug levels in Column B. I wanted to count the number of drug levels below a certain value in Column B that are within the last 6 months.

 

I currently am trying to use

=COUNTIFS(Table1[Date],">"&TODAY()-180,Table1[DrugLevel],"<=2.3")

 

It seems like all it is doing the second half (ie. counting number of levels below the value) regardless of the date in Column A.

excel
Excel for web
Formulas and Functions

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 04, 2025

    It should work. although I'd use EDATE(TODAY(), -6) instead of TODAY()-180.

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar