substracting numbers in non contigous cells

Hi!=20
I need a formula to substract numbers in non contigous=20
cells THAT ARE IN ONE COLUMN and have the result in other=20
cell, for example:


........................A...................B

R1..................................BLANKCELL
R2..................................BLANKCELL
R3..................................15
R4..................................BLANKCELL
R5..................................BLANKCELL
R6..................60.............75
R8..................................BLANKCELL
R9..................................BLANKCELL
R10................................BLANKCELL
R11................................BLANKCELL
R12................................BLANKCELL
R13................................BLANKCELL
R14..............175.............250
R15................................BLANK
R16................................BLANK
R17................................BLANK
R18................................BLANK
R19..............50...............300


Any help will be appreciated

Thanks and regards

Guillermo Padr=F3n

maybe
=sumif(a1:a21,">"&0,b1:b21)
--
Don Guillett
SalesAid Software
[email protected]
"Guillermo Padrón" <[email protected]> wrote in message
news:[email protected]...
Hi!
I need a formula to substract numbers in non contigous
cells THAT ARE IN ONE COLUMN and have the result in other
cell, for example:


........................A...................B

R1..................................BLANKCELL
R2..................................BLANKCELL
R3..................................15
R4..................................BLANKCELL
R5..................................BLANKCELL
R6..................60.............75
R8..................................BLANKCELL
R9..................................BLANKCELL
R10................................BLANKCELL
R11................................BLANKCELL
R12................................BLANKCELL
R13................................BLANKCELL
R14..............175.............250
R15................................BLANK
R16................................BLANK
R17................................BLANK
R18................................BLANK
R19..............50...............300


Any help will be appreciated

Thanks and regards

Guillermo Padrón

Thanks Don, I=B4ll try it...
Regards

Hi, Don:

I haven't tried this, but doesn't ">0" work?

On Sat, 9 Apr 2005 07:37:26 -0500, "Don Guillett" <[email protected]> wrote:

>maybe
>=sumif(a1:a21,">"&0,b1:b21)

Enter this in A2, and copy down as needed:

=IF(AND(B2>0,NOT(ISNA(LOOKUP(9.99999999999999E+307,$B$1:B1)))),B2-LOOKUP(9.9
9999999999999E+307,$B$1:B1),"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Guillermo Padrón" <[email protected]> wrote in message
news:[email protected]...
Hi!
I need a formula to substract numbers in non contigous
cells THAT ARE IN ONE COLUMN and have the result in other
cell, for example:


........................A...................B

R1..................................BLANKCELL
R2..................................BLANKCELL
R3..................................15
R4..................................BLANKCELL
R5..................................BLANKCELL
R6..................60.............75
R8..................................BLANKCELL
R9..................................BLANKCELL
R10................................BLANKCELL
R11................................BLANKCELL
R12................................BLANKCELL
R13................................BLANKCELL
R14..............175.............250
R15................................BLANK
R16................................BLANK
R17................................BLANK
R18................................BLANK
R19..............50...............300


Any help will be appreciated

Thanks and regards

Guillermo Padrón

of course.

--
Don Guillett
SalesAid Software
[email protected]
"Myrna Larson" <[email protected]> wrote in message
news:[email protected]...
> Hi, Don:
>
> I haven't tried this, but doesn't ">0" work?
>
> On Sat, 9 Apr 2005 07:37:26 -0500, "Don Guillett" <[email protected]> wrote:
>
> >maybe
> >=sumif(a1:a21,">"&0,b1:b21)
>