=SUMPRODUCT(--(B2:B200="NU"),--(F2:F200="D"),I2:I200)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AndyO_UK" wrote in message
...
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?????