For the last one you need

=SUMPRODUCT((DecMaxKms($B26-1))*(DecMaxKms<=($C26))*
(DecTruckModel(D$23-1))*(DecTruckModel<=(D$24))*
(INDIRECT("DEC"&$B$23)))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Eddy Stan" wrote in message
...
Hi,


=SUMPRODUCT(--(DecMaxKms($B26-1)),--(DecMaxKms<=($C26)),--(DecTruckModel(D
$23-1)),--(DecTruckModel<=(D$24)),INDIRECT("DEC"&$B$23))

I have ranges to find sum (sum ranges like DecHire ab8:ab19478, DecSpecial
ac8:ac19478, and so on..). At the same time I have a range name DecAll
with
range ab8:af19478, to get sum of all columns with given condition, there I
get error as "Value#".

Can You all help me out ? many thanks in advance.

When I just put = sumproduct(decall) - it is giving result, but with
condition like above it is throwing error. Am I expecting more or I have
done
some error, please help me.