Home

COUNTIF Formula Help - Embed another formula

%3CLINGO-SUB%20id%3D%22lingo-sub-319488%22%20slang%3D%22en-US%22%3ECOUNTIF%20Formula%20Help%20-%20Embed%20another%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319488%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20have%20been%20trying%20to%20figure%20out%20a%20formula%20within%20a%20formula%2C%20and%20cannot%20get%20it%20right.%20I%20have%20two%20sheets%2C%20Sheet1%20and%20Sheet%202.%20On%20Sheet%201%20I%20have%20a%20column%20of%20names.%20Some%20of%20the%20names%20are%20duplicated%20many%20times.%20On%20Sheet2%2C%20I%20have%20a%20name%20column%2C%20and%20a%20number%20column.%20I%20want%20to%20count%20how%20many%20times%20each%20name%20was%20duplicated%20on%20Sheet1.%20The%20forumla%20I%20have%20is%26nbsp%3B%3DCOUNTIF(Sheet1!%24A%242%3A%24A%2420%2C%22John%22)%20and%20it%20works.%20However%2C%20I%20have%20to%20manually%20type%20in%20the%20name%2C%20example%20%22John%22%20from%20the%20name%20column.%20Due%20to%20how%20many%20names%20I%20have%2C%20I'd%20like%20the%20formula%20to%20have%20another%20formula%20embedded%20that%20will%20pull%20the%20name%20from%20the%20column%20to%20the%20left%2C%20and%20then%20lookup%20and%20count%20on%20sheet1.%20I%20hope%20this%20makes%20sense.%20Thanks%20for%20anyone's%20help!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-319488%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECOUNTIF%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eformula%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-319508%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIF%20Formula%20Help%20-%20Embed%20another%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319508%22%20slang%3D%22en-US%22%3E%3CP%3EOl%C3%A1%20Junebug!%3C%2FP%3E%3CP%3EBasta%20usar%20a%20c%C3%A9lula%20de%20referencia%20na%20planilha%202%20em%20vez%20do%20valor.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCONT.SE(Planilha1!A%3AA%3BPlanilha2!A1)%3C%2FP%3E%3CP%3EVeja%20o%20arquivo%20em%20anexo.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
junebug
Occasional Visitor

Hi! I have been trying to figure out a formula within a formula, and cannot get it right. I have two sheets, Sheet1 and Sheet 2. On Sheet 1 I have a column of names. Some of the names are duplicated many times. On Sheet2, I have a name column, and a number column. I want to count how many times each name was duplicated on Sheet1. The forumla I have is =COUNTIF(Sheet1!$A$2:$A$20,"John") and it works. However, I have to manually type in the name, example "John" from the name column. Due to how many names I have, I'd like the formula to have another formula embedded that will pull the name from the column to the left, and then lookup and count on sheet1. I hope this makes sense. Thanks for anyone's help!!!

1 Reply

Olá Junebug!

Basta usar a célula de referencia na planilha 2 em vez do valor.

 

=CONT.SE(Planilha1!A:A;Planilha2!A1)

Veja o arquivo em anexo.

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies