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

Question

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

nikolinode · Answer

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)

sergeibaklan · Answer

lc12745&nbsp;
That could be
=COUNTIFS(names,"&lt;&gt;",dates,"&lt;&gt;")

lc12745 · Answer

SergeiBaklan&nbsp;&nbsp;Hi, attached file as you suggested.&nbsp; Need to know the number of times Katy (col. a) entered a date in "outreach cols. D &amp; E for ID #1 in Col. BThanks

sergeibaklan · Answer

lc12745&nbsp;
Sorry, what is D &amp; E and how data in column B is related to counting if names and date?
&nbsp;
Without that formula as below, even better to use PivotTable

lc12745 · Answer

thanks so much for the help

Forum Discussion

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

6 Replies

Resources