Sumproduct help

[tmmellor1981]

Morning All

firstly i apologise if this is in another thread ive searched but cannot get any to work.

i'll try and make it as simple as i can i have 2 columns USER ID (A:A) and DATE (B:B) and 2 date cells(countaing a start and end date- call it C1 and C2 which can be changed by the user)what i would like is next to a table of user names a formula that counts how many times that user name appears in the list between the 2 dates selected

tried all sorts of sumif and countifs and sumproducts none of which being me back the correct answer im guessing something like
=SUMPRODUCT((A1:A1000="USER ID")*B1:B1000>=C1)*(B1:B1000<=C2"))
with a bit of tweaking

i have every faith as i always find mr excel always comes up with an answer

many thanks

Tim

 

[VoG]

Try

=SUMPRODUCT(--(A1:A1000="USER ID"),--(B1:B1000>=C1),--(B1:B1000<=C2))

 

[tmmellor1981]

ooh i wasn't far off lol, many thanks for your help and quick response