Countif..NOW()

  • Thread starter Thread starter ftjjk
  • Start date Start date
F

ftjjk

I have a list of dates and want to count the number of cells with date
that are today or earlier. I need the count to use in another formula
I was attempting to use the following formula:

=COUNTIF(A3:A201,A3:A201<=NOW())

Any help would be appreciated
 
The reason your formula was not working was because you have a sligh
misformat of your COUNTIF arguments. The correct syntax would be:

=COUNTIF(A3:A201,"<="&NOW())

You do not need to repeat your range reference in the 2nd argument an
you needed to reformat your criteria a bit to allow the concatenatio
of the NOW function to your <= operator.

Or just use the SUMPRODUCT forumla Frank provided. :)
 
Thank you everyone. I ended up using the formula from Janet as it wa
the shortest (only by three charcters) to add in to my larger formula.
Thanks again to all
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula - Count Dates from another Sheet 8
In col if high is 83 and low 15 how do i get high =100 and low=0 2
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
Excel Need Countifs Formula Help 0
Copy Formula with Pattern 4
Countif and Sumif with refrence value a Cell on another Sheet in theWorkbook 3
Excel Copy COUNTIF while retaining reference 7

Back
Top