Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Group,
I am tring to come up with a formula. I have two columns of numbers ie. the "change" column is only for reference and illistration. ColA ColB Change 70.21 72.2 1.99 30.35 30.0 -.35 20 21 1 19 18 -1 The actual is a much longer list. I am trying to find the sum of two differances, for only the positive changes and only the negative changes. The "change" column does not really exist nor do I want to add it to the sheet, but I am looking for a formula that will these differences. I have tried several with out success. Any ideas? -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP !!! SUMIF or SUMPRODUCT | Excel Discussion (Misc queries) | |||
HELP Sumif or Sumproduct | Excel Discussion (Misc queries) | |||
sumif or sumproduct? | Excel Worksheet Functions | |||
Sumif or Sumproduct? Maybe neither? | Excel Worksheet Functions | |||
SUMIF or SUMPRODUCT or something else? | Excel Worksheet Functions |