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

"Guillermo Padrón" wrote in message
...
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" wrote:

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

Enter this in A2, and copy down as needed:

=IF(AND(B20,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" wrote in message
...
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

"Myrna Larson" wrote in message
...
Hi, Don:

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

On Sat, 9 Apr 2005 07:37:26 -0500, "Don Guillett" wrote:

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