Code Type Apr May June.....

012 X £1 £2 £1

012 y £5 £2 £1

014 X £2 £8 £4

YGD Y £2 £2 £6

The Apr, May (month columns) have the following formula in the currency cell

=IF(ISBLANK('Lesley Plan'!$F8),"", SUM(I$5*$G9))

I am using the following sumproduct function to extract a value for each month depending on the code and type eg (total value for April if Code is 012 and Type X). The sumproduct fornula is

=SUMPRODUCT(($C$9:$C$161=$Z$25)*($D$9:$D$161=$Y27)*I$9:I$161)

c9:c161 = code

z25 = select code to search for

d9:c161 = Type

y27 = type to search for

i9:161 = April values

My problem is I get the #value error from this formula.

I have change the value reference to a column that has values which are derived from a simple sum equation and it works (eg. =SUM(I29:T29)).

Any help would be very much appreciated.

Cheers

AshLad