Hi
Currently I am using Sumproduct to count column B "NU" and column F "D" but
now I also need it to look at column I (which contains the value for that
row) and then calculate that figure.

e.g. using the Sumproduct column B "NU" and column F "D" there are 34
entries so it should calculated each entry (expected value of £45,000).

Can anyone solve this problem for me?????