Row formula help please

[piggin76]

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

 

[Ron Rosenfeld]

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

 

[piggin76]

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

 

[piggin76]

managed to work it out - if anyone else needs it

=a2-(sum(c2:m2))

 

[Ron Rosenfeld]

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

You're correct. Typo Alert:

Should have been:

=a2-sum(row(1:1))



--ron

 

[Ragdyer]

Also:
=A2-Sum(1:1)

 

[Ron Rosenfeld]

Also:
=A2-Sum(1:1)

I really should stop posting without testing :-((
--ron