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

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

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

managed to work it out - if anyone else needs it

=a2-(sum(c2:m2))

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

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


You're correct. Typo Alert:

Should have been:

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



--ron

Also:
=A2-Sum(1:1)
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ron Rosenfeld" wrote in message
...
On Sun, 23 Dec 2007 05:39:01 -0800, piggin76
wrote:

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


You're correct. Typo Alert:

Should have been:

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



--ron

On Sun, 23 Dec 2007 08:28:22 -0800, "Ragdyer" wrote:

Also:
=A2-Sum(1:1)
--
Regards,

RD

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