Home

Referencing text from one worksheet in another as a COUNT, along specific rows only

%3CLINGO-SUB%20id%3D%22lingo-sub-579748%22%20slang%3D%22en-US%22%3EReferencing%20text%20from%20one%20worksheet%20in%20another%20as%20a%20COUNT%2C%20along%20specific%20rows%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-579748%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20going%20and%20I%20need%20to%20reference%20some%20data%20from%20%3CSTRONG%3ESheet%20A%3C%2FSTRONG%3E%20in%20%3CSTRONG%3ESheet%20B%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESheet%20A%3C%2FSTRONG%3E%20contains%20the%20data%2C%20and%20%3CSTRONG%3EColumn%20D%3C%2FSTRONG%3E%20is%20a%20%3CSTRONG%3EName%3C%2FSTRONG%3E%20(in%20this%20case%20let's%20look%20for%20%3CSTRONG%3EPerson%201%3C%2FSTRONG%3E).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20count%20of%20%3CSTRONG%3EObjects%3C%2FSTRONG%3E%20(in%20this%20case%20let's%20say%20%3CSTRONG%3EObject%204%3C%2FSTRONG%3E)%20in%20%3CSTRONG%3EColumns%20F%20to%20I%3C%2FSTRONG%3E%2C%20along%20only%20those%20rows%20where%20%3CSTRONG%3EColumn%20D%3C%2FSTRONG%3E%20is%20the%20same%20as%20a%20particular%20cell%20(with%20the%20same%20%3CSTRONG%3EName%3C%2FSTRONG%3E)%20in%20the%20second%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20instance...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3EPerson%201%2CObject%201%2CObject%202%2CObject%203%2CObject%204%3CBR%20%2F%3E%3CBR%20%2F%3EPerson%202%2CObject%201%2CObject%202%2CObject%203%2CObject%204%3CBR%20%2F%3E%3CBR%20%2F%3EPerson%202%2CObject%204%2CObject%204%2CObject%204%2CObject%204%3CBR%20%2F%3E%3CBR%20%2F%3EPerson%202%2CObject%201%2CObject%202%2CObject%203%2CObject%204%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20COUNT%20all%20of%20the%20instances%20of%20%3CSTRONG%3EObject%204%3C%2FSTRONG%3E%20attached%20to%20%3CSTRONG%3EPerson%202%3C%2FSTRONG%3E.%20The%20first%20row%20of%20the%20second%20worksheet%20is%20labelled%20with%20%3CSTRONG%3EPerson%201%2CPerson%202%2CPerson%203%2CPerson%204%3C%2FSTRONG%3E.%20I%20obviously%20can't%20do%20a%20full%20count%20of%20the%20entire%20table%20of%20data%20since%20this%20will%20also%20return%20instances%20of%20%3CSTRONG%3EObject%204%3C%2FSTRONG%3E%20attached%20to%20%3CSTRONG%3EPerson%201%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnybody%20have%20any%20idea%20on%20a%20solution%3F%20This%20is%20way%20above%20me.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-579748%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-580605%22%20slang%3D%22en-US%22%3ERe%3A%20Referencing%20text%20from%20one%20worksheet%20in%20another%20as%20a%20COUNT%2C%20along%20specific%20rows%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-580605%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F343645%22%20target%3D%22_blank%22%3E%40sun600net%3C%2FA%3E%26nbsp%3B%2C%20you%20may%20count%20by%20COUNTIF()%20or%20COUNTIFS()%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
sun600net
Occasional Visitor

I have a spreadsheet going and I need to reference some data from Sheet A in Sheet B.

 

Sheet A contains the data, and Column D is a Name (in this case let's look for Person 1).

 

I need a count of Objects (in this case let's say Object 4) in Columns F to I, along only those rows where Column D is the same as a particular cell (with the same Name) in the second worksheet.

 

For instance...

 

Person 1,Object 1,Object 2,Object 3,Object 4

Person 2,Object 1,Object 2,Object 3,Object 4

Person 2,Object 4,Object 4,Object 4,Object 4

Person 2,Object 1,Object 2,Object 3,Object 4

 

I need to COUNT all of the instances of Object 4 attached to Person 2. The first row of the second worksheet is labelled with Person 1,Person 2,Person 3,Person 4. I obviously can't do a full count of the entire table of data since this will also return instances of Object 4 attached to Person 1.

 

Anybody have any idea on a solution? This is way above me.


Thanks in advance.

1 Reply

@sun600net , you may count by COUNTIF() or COUNTIFS()

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies