substracting numbers in non contigous cells

  • Thread starter Guillermo Padrón
  • Start date
G

Guillermo Padrón

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
 
D

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Substracting numbers in non contigous cells 1
Developing Macros 2
extracting data from columns to summary sheet 0
Help wCombo Box Setup 1
Multiple criteria search 5
Word2008 does not launch 2
Word 2008 Will Not Launch on iMac G5 3
can i avoid repeating rows when adding calculated item in pivot ta 4

Top