COUNT INBETWEEN A DATE RANGE

D

Dave

Hi

Does anyone know how to count the number of occurences between a data range?

Thanks
 
T

Teethless mama

let's say your criteria in C1: early date, D1: latest date
date in column A, and number in column B

=SUMPRODUCT((A1:A100>=C1)*(A1:A100<=D1)*(B1:B100<>""))
 
R

Ron Rosenfeld

Hi

Does anyone know how to count the number of occurences between a data range?

Thanks
Click to expand...

=countif(rng,">=" & StartDate) - countif(rng,">" & EndDate)

--ron
 
F

Fred Smith

That's what TM assumed. What happened when you tried his suggestion?

Regards,
Fred
 

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

Count Inbetween dates 3
Count Dates & Return as % 2
Counting days between dates 8
Excel VBA - counting cells by colors and names to it in two different rows. 0
Count Numbers Only Once in a Range 7
Count specific days in between dates 2
Counting text which meets a criteria 2
COUNT BETWEEN A RANGE AND 16

Top