Sumproduct (I think)

[jamiedavies02]

Hi

I have a problem, I'll try and explain it best I can, I have 2 identical size tables; one containing text values and the other containing numerical values.

The text values are football team names in position 1-4, the numerical value is the teams points in positions 1-4. Basically I've simulated a World Cup group 10,000 times.

Using the below table as an example, what I'd like to do is count the number of times each team finishes on a certain number of points. Basically I want to create another table to count how many times Uruguay finish with 0 points, 1 point, 2 points etc

My question is, how is the quickest and easiest way to do this?

 

[SpillerBD]

Re: Sumproduct (I think) Help

"That depends."
What Excel version are you using?

Of course, using PowerBI Desktop to run the query that Unpivots/Links the data into a single two-column data-set and then do a little dash-boarding...