Hi, so i have this formula that works fine
=COUNTIF(leads!AD2:AD2224,"Loan Plus Accountancy") + COUNTIF(leads!$AD$2:$AD$2224,"Loan Only")
I have added to cells A13 & B13 to add from to dates and tried to see if i could get formula to work but just couldn't get it to work if one of you great guys can it would be really great. This was my attempt
=COUNTIF(((leads!AD2:AD2224,"Loan Plus Accountancy") + COUNTIF(leads!$AD$2:$AD$2224,"Loan Only"))>=$A$13)*(((leads!AD2:AD2224,"Loan Plus Accountancy") + COUNTIF(leads!$AD$2:$AD$2224,"Loan Only"))<=$B$13)
The 2nd part is then on click of cell opens calendar to choose dates from
Thank you
=COUNTIF(leads!AD2:AD2224,"Loan Plus Accountancy") + COUNTIF(leads!$AD$2:$AD$2224,"Loan Only")
I have added to cells A13 & B13 to add from to dates and tried to see if i could get formula to work but just couldn't get it to work if one of you great guys can it would be really great. This was my attempt
=COUNTIF(((leads!AD2:AD2224,"Loan Plus Accountancy") + COUNTIF(leads!$AD$2:$AD$2224,"Loan Only"))>=$A$13)*(((leads!AD2:AD2224,"Loan Plus Accountancy") + COUNTIF(leads!$AD$2:$AD$2224,"Loan Only"))<=$B$13)
The 2nd part is then on click of cell opens calendar to choose dates from
Thank you