Hi there
I just need a quick bit of advice on how to get a cell to be blank instead
of showing the above error whenever no data is entered in a selected cell
range.

The formula i'm using is something like
=Sumproduct(C1:C4,D1:D4)/F1
I've tried the IF rule but it only works on the first set, but not on the
second set, it starts returning #Value!
Formula used was
=IF(C1:C4="","",Sumproduct(C1:C4,D1:D4)/F1)
The above formula did return a blank cell untill data entered in the first
range.
But when i moved on to the next formula it returned #VALUE!
The formula i tried was the same but in the next set of cells down.
=IF(C5:C8="","",Sumproduct(C5:C8,D5:D8)/F2)

Can anyone who understands what i've just said :) please help.

Many thanks
Iain