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

%3CLINGO-SUB%20id%3D%22lingo-sub-1784365%22%20slang%3D%22en-US%22%3Eneed%20formula%20for%202%20conditions%2C%20one%20condition%20being%20count%20non%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1784365%22%20slang%3D%22en-US%22%3E%3CP%3Ehave%20spreadsheet%20with%20representative%20name%20in%20one%20column%20and%20dates%20in%20another%20column.%26nbsp%3B%20Need%20formula%20to%20count%20if%20rep%20name%20and%20date%20exist%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1784365%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1784408%22%20slang%3D%22de-DE%22%3ESubject%3A%20need%20formula%20for%202%20conditions%2C%20one%20condition%20being%20count%20non%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1784408%22%20slang%3D%22de-DE%22%3EWith%20your%20permission%2C%20add%20a%20file%20(without%20sensitive%20data)%20and%20describe%20exactly%20what%20your%20plan%20is%2C%20so%20you%20can%20get%20an%20answer%20faster.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%20%3CBR%20%2F%3E%20I%20know%20that%20I%20know%20nothing%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1784508%22%20slang%3D%22en-US%22%3ERe%3A%20need%20formula%20for%202%20conditions%2C%20one%20condition%20being%20count%20non%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1784508%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F833870%22%20target%3D%22_blank%22%3E%40lc12745%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCOUNTIFS(names%2C%22%26lt%3B%26gt%3B%22%2Cdates%2C%22%26lt%3B%26gt%3B%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
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)
Highlighted

@lc12745 

That could be

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

@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

Highlighted

@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

Highlighted
Highlighted