substracting numbers in non contigous cells

[=?iso-8859-1?Q?Guillermo_Padr=F3n?=]

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

 

[Don Guillett]

maybe
=sumif(a1:a21,">"&0,b1:b21)
--
Don Guillett
SalesAid Software
(e-mail address removed)
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

 

[gpadronn]

Thanks Don, I´ll try it...
Regards

 

[Myrna Larson]

Hi, Don:

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

 

[RagDyeR]

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!
==============================================


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

 

[Don Guillett]

of course.