| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Deviation is positive
I'd like to calculate the sum of all postive deviations of two time series. Is there a way to do this without additional calculations in seperate column? I tried this, but it doesn't seem to work =sumif(C1:C100-B1:B100,"0") Any suggestions? Thy very much |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif Deviation is positive
Kind of figured it out myself:
={SUM(IF((C1:C100-B1:B100)0,C1:C100-B1:B100))} Thx for reading anyway |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif Deviation is positive
Hi,
Try this =sumproduct((C1:C100-B1:B100)*(C1:C100-B1:B1000)) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "chg" wrote in message ... I'd like to calculate the sum of all postive deviations of two time series. Is there a way to do this without additional calculations in seperate column? I tried this, but it doesn't seem to work =sumif(C1:C100-B1:B100,"0") Any suggestions? Thy very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Standard deviation | Excel Discussion (Misc queries) | |||
| Standard Deviation | Excel Worksheet Functions | |||
| Sumif using dates and positive negative values | Excel Discussion (Misc queries) | |||
| standard deviation | Excel Discussion (Misc queries) | |||
| SUMIF positive values only from database | Excel Worksheet Functions | |||
Linear Mode
