need formula for 2 conditions, one condition being count non blank

Copper Contributor

have spreadsheet with representative name in one column and dates in another column.  Need formula to count if rep name and date exist

6 Replies
With your permission, add a file (without sensitive data) and describe exactly what your plan is, so you can get an answer faster.

Thank you for your understanding and patience.

Nikolino
I know that I know nothing (Socrates)

@lc12745 

That could be

=COUNTIFS(names,"<>",dates,"<>")

@Sergei Baklan 

 

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

@lc12745 

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

image.png

thanks so much for the help