Thanks Becky for quick response.

No, I want a formula which adds the number of points using column B and C (of attached sheet's, snapshot). and show the sum on specific coordinate of heat-map (Matrix with different colors as shown).

I have manually done by taking example of 5 risks.

There are two risks with probability 2 and Impact 4 (Risk 1 and Risk 3) so "2" is being displayed on coordinates 2,4 (Likelihood, Impact), Similarly there is one risk (Risk 2) with probability 3 and Impact 5, so 1 is appearing on coordinate 3,5 and so on...

The numbers shown on matrix are entered manually. We have long lists and therefore looking for a formula to plot the data on matrix automatically when values in column B and C are entered.

Please let me know if further clarification is required.