May 16 2019 10:47 PM
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.
May 17 2019 12:34 AM
@sun600net , you may count by COUNTIF() or COUNTIFS()