Thanks Ron, but that just minuses the row number from the cell figure rather
than adding the row contents together then minusing it from the cell figure

"Ron Rosenfeld" wrote:

On Sun, 23 Dec 2007 05:15:01 -0800, piggin76
wrote:

Hi, I need a formula that will add all figures in a row except zero or blank
cells and then minus that figure from another cell figure - does anyone know
how to do that please? thanks


=a2-row(1:1)


--ron