Please see table below.
I'm trying to figure out how to do a lookup for these values?
For example if I wanted to know how many CPU's were sold by Dell, the answer below is 11. But what would be the way to do that lookup? I know how to do vlookups and sumifs but can't figure this one out.
Thanks!
<tbody>
</tbody>
I'm trying to figure out how to do a lookup for these values?
For example if I wanted to know how many CPU's were sold by Dell, the answer below is 11. But what would be the way to do that lookup? I know how to do vlookups and sumifs but can't figure this one out.
Thanks!
Walmart | Target | Dell | Amazon | |
Toothbrush | 1 | 2 | 3 | 4 |
Toothpaste | 5 | 6 | 7 | 8 |
CPU | 9 | 10 | 11 | 12 |
Monitor | 13 | 14 | 15 | 16 |
<tbody>
</tbody>