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
kat...
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