Countif cells in a range equal to a date specifed in a cell

  • Thread starter Thread starter Allan
  • Start date Start date
A

Allan

I need to count the number of cells in a column of many
dates, that match a particular date, and it would be
easier to reference a cell with the particular date in it.

Instead of

=COUNTIF($A$2:$A$1123,"15-Jan")

I would like something like

=COUNTIF($A$2:$A$1123,"$F$1142")

Is this possible?

TIA

Allan Fromm
Green Bay, WI
 
Hi Allan
just try
=COUNTIF($A$2:$A$1123,$F$1142)
(remove the apostophes then using a cell reference - otherwise Excel
interprets "$F$1142" as text)


HTH
Frank
 
Back
Top