how to output a number

[Beijin Yu]

Hi, how do i write an Excel formula that would output the total number of contacts Lucy had on Februray 14. thanks!!

  A            B           C

Date	Login	Contacts
12-Feb	kate	110
12-Feb	Lucy	110
13-Feb	Kate	120
13-Feb	Lucy	140
14-Feb	Kate	120
14-Feb	Lucy	100
15-Feb	Kate	60
15-Feb	Lucy	130

[#2]

Hi,

If in column A is full date formatted as dd-mmm, when

=SUMPRODUCT((B2:B100="Lucy")*(A2:A100=<your date>)*C2:C100)

or like