#VALUE! problem

C

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
 
K

keith6973

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

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
 
Top