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 |
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 |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com