Add date range using From & To cells

[censura]

Hi i did post this earlier but maybe the existing formula was not very clear so though i would try with a different example

So i have this formula

=COUNTIF(leads!$M$3:leads!$M$1439,"Failed Credit Check")

that counts instances in column M of a record sheet that has the date in column A

what i would like is to run the formula but be able to select a date range by adding a from and to date in say cell $N1$ & $O$1

so that rather than getting a count for all instances it only counts for the rows that have 'Failed Credit Check' in column M but in date range set in cells $N1$ & $O$1 for e.g 1/2/2021 - 28/2/21

Thank you so much for your help here

 

[steve the fish]

You cant with COUNTIF. You can with COUNTIFS.

=COUNTIFS(leads!$M$3:$M$1439,"Failed Credit Check",leads!$A$3:$A$1439,">="&$N$1,leads!$A$3:$A$1439,"<"&$O$1+1)

 

[censura]

You cant with COUNTIF. You can with COUNTIFS.

=COUNTIFS(leads!$M$3:$M$1439,"Failed Credit Check",leads!$A$3:$A$1439,">="&$N$1,leads!$A$3:$A$1439,"<"&$O$1+1)

Works a treat thank you so much, is it possible to add the condition if cell $N$1 says All treats as all records

 

[steve the fish]

You would just put in a catch all date range. Say 1/1/1900 to 31/12/2100 or something similar.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Add a date range search using From & To cells
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.