Oct 15 2020 08:58 AM
have spreadsheet with representative name in one column and dates in another column. Need formula to count if rep name and date exist
Oct 15 2020 09:05 AM
Oct 15 2020 09:19 AM
Oct 15 2020 10:19 AM
Hi, attached file as you suggested. Need to know the number of times Katy (col. a) entered a date in "outreach cols. D & E for ID #1 in Col. B
Thanks
Oct 15 2020 03:04 PM
Sorry, what is D & E and how data in column B is related to counting if names and date?
Without that formula as below, even better to use PivotTable
Oct 19 2020 03:41 AM
thanks so much for the help
Oct 19 2020 09:38 AM
@lc12745 , you are welcome