| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
|
|
#3
|
|||
|
|||
|
Thanks Don, I=B4ll try it...
Regards |
|
#4
|
|||
|
|||
|
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) |
|
#5
|
|||
|
|||
|
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) |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count cells with unique numbers | Excel Worksheet Functions | |||
| How do i get the top 5 numbers in a range of cells? | Excel Worksheet Functions | |||
| update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) | |||
| Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
Hybrid Mode
