counting depedent on date

[silentcoates]

Hi

I have the following countif formula

=COUNTIF($B$3:$B$1260,M2)

How do I amend it only to count names in column B between two dates (which I specify in cells I2 and J2)

thanks

 

[Peter_SSs]

Hi

I have the following countif formula

=COUNTIF($B$3:$B$1260,M2)

How do I amend it only to count names in column B between two dates (which I specify in cells I2 and J2)

thanks

Assuming there are dates in column A beside the names in column B, try this (untested).

=SUMPRODUCT(--($A$3:$A$1260<J2),--($A$3:$A$1260>I2),--($B$3:$B$1260=M2))

 

[silentcoates]

spot on

Thanks for your help