I've seen a few of the forums in here with similar requests - how to take a column of data and where there's matches, total the sum of those cells. The consensus seems to be to use SUMIF instead, but I do think I need to use VLOOKUP.
My goal is to analyze the data, and output a tallied set of results. Here's an example:
<tbody>
</tbody>
I have hundreds of people in column A, Column B is the total value I'd like to sum up, and Column C is the various Products. I have about 10 products that feature.
I'd like to use a formula that then takes the table data and outputs a summary (by total of column B, per person)
<tbody>
</tbody>
And, I'd also like to have a formula that takes the table data and outputs a summary (by total of Product and its summed total of value)
Appreciate any help you can provide!
Thanks.
My goal is to analyze the data, and output a tallied set of results. Here's an example:
A | B | C |
Person 1 | $500 | Product 1 |
Person 2 | $500 | Product 2 |
Person 3 | $500 | Product 3 |
Person 1 | $500 | Product 2 |
Person 3 | $500 | Product 2 |
Person 1 | $500 | Product 1 |
<tbody>
</tbody>
I have hundreds of people in column A, Column B is the total value I'd like to sum up, and Column C is the various Products. I have about 10 products that feature.
I'd like to use a formula that then takes the table data and outputs a summary (by total of column B, per person)
A | B |
Person 1 | $1500 |
Person 2 | $500 |
Person 3 | $1000 |
<tbody>
</tbody>
And, I'd also like to have a formula that takes the table data and outputs a summary (by total of Product and its summed total of value)
Appreciate any help you can provide!
Thanks.