Hi there.
I've been banging my head on this for too long, and everything I search up never gets me to the right place. So here is the scenario, and what I am looking for.
Data:
My data is given to me as converted from JSON, which means that the headers are never in the same place, except for the first few. Luckily the value I want to sum is always in column A.
Example:
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Value[/TD]
[TD]Account[/TD]
[TD]Name1[/TD]
[TD]Name2[/TD]
[TD]Name3[/TD]
[TD]Name4[/TD]
[TD]Name5[/TD]
[TD]Name6[/TD]
[TD]Name7[/TD]
[TD]Name8[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]150000[/TD]
[TD]Acme[/TD]
[TD]Kyle[/TD]
[TD]Sam[/TD]
[TD]Sarah[/TD]
[TD]Tim[/TD]
[TD]Melissa[/TD]
[TD]Brian[/TD]
[TD]Laura[/TD]
[TD]Karl[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]250000[/TD]
[TD]Walmart[/TD]
[TD]Sarah[/TD]
[TD]Kyle[/TD]
[TD]Kenny[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]50000[/TD]
[TD]Target[/TD]
[TD]Sarah[/TD]
[TD]Tim[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]325000[/TD]
[TD]Kmart[/TD]
[TD]Melissa[/TD]
[TD]George[/TD]
[TD]Kenny[/TD]
[TD]Laura[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Parameters:
I have a list of all of my employee names on a separate tab. These should be my search parameters for each row in my data.
Example:
Brian
George
Karl
Kenny
Kyle
Laura
Melissa
Sam
Sarah
Tim
Results:
Next to each of my employee names, I want to see the total sum of each value is A1 for every row that each employee name is present. As you can see from my data example, the names are almost never in the same column. So, if "Laura" exists anywhere within rows 2 and 5, then the number next to her name should be "475000" (the sum of A2 and A5).
I would greatly appreciate any ideas.
Thank you!
I've been banging my head on this for too long, and everything I search up never gets me to the right place. So here is the scenario, and what I am looking for.
Data:
My data is given to me as converted from JSON, which means that the headers are never in the same place, except for the first few. Luckily the value I want to sum is always in column A.
Example:
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Value[/TD]
[TD]Account[/TD]
[TD]Name1[/TD]
[TD]Name2[/TD]
[TD]Name3[/TD]
[TD]Name4[/TD]
[TD]Name5[/TD]
[TD]Name6[/TD]
[TD]Name7[/TD]
[TD]Name8[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]150000[/TD]
[TD]Acme[/TD]
[TD]Kyle[/TD]
[TD]Sam[/TD]
[TD]Sarah[/TD]
[TD]Tim[/TD]
[TD]Melissa[/TD]
[TD]Brian[/TD]
[TD]Laura[/TD]
[TD]Karl[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]250000[/TD]
[TD]Walmart[/TD]
[TD]Sarah[/TD]
[TD]Kyle[/TD]
[TD]Kenny[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]50000[/TD]
[TD]Target[/TD]
[TD]Sarah[/TD]
[TD]Tim[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]325000[/TD]
[TD]Kmart[/TD]
[TD]Melissa[/TD]
[TD]George[/TD]
[TD]Kenny[/TD]
[TD]Laura[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Parameters:
I have a list of all of my employee names on a separate tab. These should be my search parameters for each row in my data.
Example:
Brian
George
Karl
Kenny
Kyle
Laura
Melissa
Sam
Sarah
Tim
Results:
Next to each of my employee names, I want to see the total sum of each value is A1 for every row that each employee name is present. As you can see from my data example, the names are almost never in the same column. So, if "Laura" exists anywhere within rows 2 and 5, then the number next to her name should be "475000" (the sum of A2 and A5).
I would greatly appreciate any ideas.
Thank you!