counting depedent on date

silentcoates

New Member
Joined
Oct 11, 2005
Messages
41
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
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,470
Office Version
  1. 365
Platform
  1. Windows
silentcoates said:
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).
Code:
=SUMPRODUCT(--($A$3:$A$1260<J2),--($A$3:$A$1260>I2),--($B$3:$B$1260=M2))
 

Watch MrExcel Video

Forum statistics

Threads
1,118,033
Messages
5,569,777
Members
412,291
Latest member
marypolitan
Top