Sum / index matching

[rjmcguire]

Hi All,

For the life of me I cannot think of a function I can make work to sum the totals of various products against a unique reference code. Basically I want to to know how much in total of each product I need to purchase from summating Volumes in Column E and giving output in column E, using the unique Navision code in column B and I.

Thanks in advance

 

[Legacy 396030]

If you could submit a screen shot. So you want the sum total from column E when B and I match?

 

[rjmcguire]

Yep. Can you not see screen shot?