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...