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