D
Dave
I have a formula in my worksheet
=IF(ISERR(J7+J8+J9+J10+J11),"Error",J7+J8+J9+J10)
it works just fine for adding 4 cells together
and it returns the word "error" if other cells that
add numbers to arrive at J7, J8, etc have errors in them.
My problem is I can't get the formula right to sum all
the cells in column J by using the normal =sum(J7:J60)
approach in the formula above.
Thanks for any help in advance
=IF(ISERR(J7+J8+J9+J10+J11),"Error",J7+J8+J9+J10)
it works just fine for adding 4 cells together
and it returns the word "error" if other cells that
add numbers to arrive at J7, J8, etc have errors in them.
My problem is I can't get the formula right to sum all
the cells in column J by using the normal =sum(J7:J60)
approach in the formula above.
Thanks for any help in advance