#VALUE! problem

[chief]

i have a sheet set up with formulas in cells such a
=SUM(A1*D1)+SUM(B1*E1), etc..
i want to have totals at the bottom of the columns but they won'
produce totals for me when i sum(F1:F300) for instance, it only return
a #VALUE! because there are some cells which don't have numbers. i
code or something that will delete all cells which have #VALUE! i
them, and keep all actual value cells

 

[keith6973]

Try going through all the cells in your range and hit delete for thos
that don't have numbers in them

 

[Frank Kabel]

Hi
change your formula to
=N(A1)*N(D1)+N(B1)*N(E1)

no need for a SUM function and the N function will deal with Text
values in these cells