COUNTIFS question

[Cummins]

I am attempting to count the occurrences where column B contains the value in A3 AND column B equals 1 AND where column J is as recent as 3 months ago. Could you share some wisdom?

=COUNTIFS('Raw Data'!B:B,A3,'Raw Data'!C:C,1,'Raw Data'!J:J,">TODAY()-90")

 

[VoG]

Perhaps

=COUNTIFS('Raw Data'!B:B,A3,'Raw Data'!C:C,1,'Raw Data'!J:J,">"&TODAY()-90)

 

[Aladin Akyurek]

I am attempting to count the occurrences where column B contains the value in A3 AND column B equals 1 AND where column J is as recent as 3 months ago. Could you share some wisdom?

=COUNTIFS('Raw Data'!B:B,A3,'Raw Data'!C:C,1,'Raw Data'!J:J,">TODAY()-90")

=COUNTIFS('Raw Data'!B:B,A3,'Raw Data'!C:C,1,'Raw Data'!J:J,">"&TODAY()-90)

Also...

=COUNTIFS('Raw Data'!B:B,A3,'Raw Data'!C:C,1,'Raw Data'!J:J,">="&EDATE(TODAY(),-3))

 

[Robert Mika]

=COUNTIFS('RAW Data'!B:B,A3,'RAW Data'!C:C,1,'RAW Data'!J:J,">"&TODAY()-90)

And just to mention to not use the hole data range (A:A...) as your calculation slows down.