Support Board

Date/Time: Fri, 19 Apr 2024 08:09:14 +0000

Post From: Volume by Price in spraedsheet

[2014-01-26 21:30:15] Link To Thread - Link To Post [Go To First Post]
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