Countifs query

[Corleone]

hi im trying to use a countifs query to count up how many dates fall within each period date (period dates are all in row 1
the example below is looking at the source data in column a and trying to calculate how many dates in this range fall between the period dates in N1 and O1


=COUNTIFS($O$37:$O$80,=>N1,$O$37:$O$80,<=O1)

However its not accepting it as a formula

any help appreciated

Thanks

 

[Fluff]

You need to put the comparators in quotes like

=COUNTIFS($O$37:$O$80,">="&N1,$O$37:$O$80,"<="&O1)

 

[Corleone]

Top bananas

that works

cheers

 

[Fluff]

You're welcome & thanks for the feedback.