Home

Counting names

%3CLINGO-SUB%20id%3D%22lingo-sub-690961%22%20slang%3D%22en-US%22%3ECounting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690961%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%2Fcalendar%20with%20employee%20names%20on%20the%20days%20they%20are%20taking%20off%20for%20vacation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20a%20way%20to%20have%20a%20count%20of%20how%20many%20times%20a%20name%20appears%20in%20any%20cell%20even%20if%20it%20already%20contains%20other%20names.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20have%204%20guys%20taking%20the%20same%20day%20off%20but%20I%20cannot%20seem%20to%20create%20a%20formula%20to%20have%20it%20count%20the%20name.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20Advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-690961%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-691184%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691184%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359917%22%20target%3D%22_blank%22%3E%40nicklesontool%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20like%3C%2FP%3E%0A%3CPRE%3E%3DSUMPRODUCT(ISNUMBER(SEARCH(%22Name%22%2C%24A%241%3A%24D%241))*1)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692494%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewere%20do%20i%20put%20the%20search%20criteria%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692515%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692515%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359917%22%20target%3D%22_blank%22%3E%40nicklesontool%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20633px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118121i06F42F7ECDA5E3E4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ebut%20I%20have%20no%20idea%20how%20is%20your%20data%20looks%20like%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692659%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20have%20attached%20the%20file%20for%20your%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20know%20how%20many%20times%20an%20employee's%20name%20appears%20in%20a%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20your%20formula%20and%20it%20did%20not%20work%20for%20me.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692767%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692767%22%20slang%3D%22en-US%22%3E%3CP%3ETry%20this%3A%3CBR%20%2F%3E%3DCOUNTIF(A2%3AY55%2C%22*EMPLOYEE%20NAME%20HERE*%22)%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359917%22%20target%3D%22_blank%22%3E%40nicklesontool%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692968%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692968%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359917%22%20target%3D%22_blank%22%3E%40nicklesontool%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBoth%20above%20formulas%20work%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20521px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118134i11C8B658DBDD8FF2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20check%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
nicklesontool
New Contributor

I have a spreadsheet/calendar with employee names on the days they are taking off for vacation.

 

I am trying to find a way to have a count of how many times a name appears in any cell even if it already contains other names.

 

I could have 4 guys taking the same day off but I cannot seem to create a formula to have it count the name.

 

Thanks in Advance.

6 Replies

@nicklesontool ,

 

That could be like

=SUMPRODUCT(ISNUMBER(SEARCH("Name",$A$1:$D$1))*1)

@Sergei Baklan thank you.

 

were do i put the search criteria?

@nicklesontool 

 

That's like this

image.png

but I have no idea how is your data looks like

@Sergei Baklan I have attached the file for your reference.

 

I need to know how many times an employee's name appears in a cell.

 

I tried your formula and it did not work for me. 

Try this:
=COUNTIF(A2:Y55,"*EMPLOYEE NAME HERE*")

@nicklesontool 

@nicklesontool 

 

Both above formulas work

image.png

Please check attached.