Countifs?

[nashetho]

I have a sheet for tracking activities that is filled inw ith a MS Form.

I have a countif for a total count of key words in column N
I would like to be able to do a count of the key words but limited to within the last 3 months, The date is in column F.

I thought a countifs might work but I am not great with excel and wondered if anyone could assist with the appropriate formula.

The current countif for the total is: =COUNTIF(sheet1!N2:N999,"*Intubation*")

Cheers
Chris

 

[Sufiyan97]

Hi & Welcome to MrExcel.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[nashetho]

Hi unfortunately my spreadsheet is within a secure NHS system which wont let me copy out data sorry.

 

[Sufiyan97]

Okay,

Try

=COUNTIFS(Sheet1!N2:N999,"*Intubation*",Sheet1!F2:F999,">="&DATE(2024,1,1),Sheet1!F2:F999,"<="&DATE(2024,3,1))

Add your start date in this part - DATE(2024,1,1)
Add your end date in this part - DATE(2024,3,1)

 

[Cubist]

One more option:

=COUNTIFS(sheet1!N:N,"*Intubation*",sheet1!F:F,">="&EDATE(TODAY(),-3))