Count Number

[drezaie]

i have 2 Column : one of is Name and another is Date
i want to count the number of User between to time:
for exc :
David 1-Oct
David 1-OCt
David 1-Oct
David 1-Oct
David 1-Oct
Peter 1-Oct
Peter 2-Oct
David 2-Oct

...

from "1-Oct" up to "2-Oct" "David" is "6"

how can to do it ?
please help me

[BadlySpelledBuoy]

In cell I3 :

Please Login or Register  to view this content.

BSB

[bebo021999]

Try COUNTIFS:

=COUNTIFS($B$2:$B$45,H3,$C$2:$C$45,"<="&G3,$C$2:$C$45,">="&F3)

[José Augusto]

Or try
=SUMPRODUCT(--($C$2:$C$45>=$F$3),--($C$2:$C$45<=$G$3),--($B$2:$B$45=$H$3))

[drezaie]

Tanks So much