CODEWITHSUNDEEP
exceldateexcel-formulacountif
N30C0rt3X
N30C0rt3X

Reputation: 31

Excel COUNTIFS between date range

How do I count between a date range using COUNIFS? The dates are set as columns The_Date_Start and The_Date_End.

My formula is

=COUNTIFS(Sheet2!C:C,[@Tel],Sheet2!A:A,"<="&[@[The_Date]])

I have tried something like the below but doesn't work

=COUNTIFS(Sheet2!C:C,[@Tel],Sheet2!A:A,"=>"&[@[The_Date_Start]],"<="&[@[The_Date_End]])

Upvotes: 1

Views: 346

Answers (1)

Gangula
Gangula

Reputation: 7274

You can use this formula:

=COUNTIFS([ColToCount], ">="&[@End], [ColToCount], "<="&[@Start])

Note that all the ranges should be of same length. In your formula, they are of different lengths

Upvotes: 1

Related Questions