Forum Discussion
how to output a number
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 |
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
