Feb 23 2018
07:40 AM
- last edited on
Jul 25 2018
11:09 AM
by
TechCommunityAP
Feb 23 2018
07:40 AM
- last edited on
Jul 25 2018
11:09 AM
by
TechCommunityAP
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 |
Feb 23 2018 07:45 AM - edited Feb 23 2018 07:53 AM
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