Count the Days in a Range if

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to count the number of days in a range called "Dates" as long as
those Dates are referenced by what is in cell A8, what I mean by Reference
is that what appears in A8 also appears in each row in Column A - on another
worksheet and the Dates appear in Column B on this other worksheets. I've
used range names as the data within is dynamic. I used the following
formula, which doesn't work

=Countif(Restaurants=A8,(Max(Dates)-Min(Dates)))
 
the Syntax for COUNTIF is:

COUNTIF(range,criteria)

=COUNTIF(dates,A8) might work for you..........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top