Support Board
Date/Time: Mon, 25 Nov 2024 09:38:23 +0000
Post From: Volume by Price in spraedsheet
| [2014-01-26 21:30:15] |
| vegasfoster - Posts: 444 |
|
1. I don't understand what you are asking for, but in general you can use the sumif function if you only have one parameter, e.g. =sumif(a1:a300, "<"&X, b1:b300). If you have two parameters then you could try to use an array formula, e.g. {=sum(if(a1:a300<X, if(b1:b300<Y, b1:b300)))}. Where X and Y are values or cell references containing the values you want to evaluate against. I don't use array formulas very often, so I am not sure how much more efficient this would be, you will need to test it. Link to brief explanation of array formulas. http://spreadsheets.about.com/od/2010statisticalfunctions/qt/2010-04-26-excel-2010-min-function.htm 2. As far as I know, currently you can't do this because the information is not output by the study and SC does not make the source code available for this study. Your options are to ask for the source code or recode the study yourself. Date Time Of Last Edit: 2014-01-26 21:34:57
|