What sort of data do you have in the cells? You may be able to use the
subtotal function to add data in groups, by sorting first on the relevant
columns and using data - subtotals in 2003 or the subtotals option on the
ribbon in 2007. Can you give a bit more detail?

"Chris" wrote:

I need help with totaling a range of cells G12:G46. My problem is that not
all cells contain values for the formula in these cells so it is not allowing
me to do so. This is on a quote sheet and I would like to subtotal as I go,
can anyone help?
--
Chris