Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT for other Excel functions?
Hello, I was referred to the SUMPRODUCT function that has formidable
advantages for counting and summing according to criteria on the range What if I have to calculate other functions sunch as standard deviation or percentile according to som criteria on the range? Could SUMPRODUCT help me for that or is there another not involving looping ? Thanks for your help Avi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT for other Excel functions?
You need to use array functions. See http://www.cpearson.com/excel/arrayformulas.aspx for explanations and examples. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 25 Dec 2008 02:25:54 -0800 (PST), avi wrote: Hello, I was referred to the SUMPRODUCT function that has formidable advantages for counting and summing according to criteria on the range What if I have to calculate other functions sunch as standard deviation or percentile according to som criteria on the range? Could SUMPRODUCT help me for that or is there another not involving looping ? Thanks for your help Avi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wildcards in sumproduct functions | Excel Worksheet Functions | |||
Excel : Nesting of functions such as sumproduct and sumif | Excel Worksheet Functions | |||
Functions that can be used with Sumproduct | Excel Discussion (Misc queries) | |||
sumproduct and average functions | Excel Worksheet Functions | |||
Sumproduct & Indirect Functions | Excel Worksheet Functions |