see your other post

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
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