View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default sumproduct? sumif(sumproduct)?

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