tag:blogger.com,1999:blog-2509167754737584590.post23291451363166412..comments2010-05-02T09:08:58.713+05:30Yogesh Guptahttp://www.blogger.com/profile/08246342663404873564noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2509167754737584590.post-35578811339586655512010-05-02T09:08:58.706+05:302010-05-02T09:08:58.706+05:30@ SmprFidels<br /><br />Formula will not work the way you have constructed it. How ever if your data has less then 5 numbers you can use sum instead of sumproduct as above. This can be handled using if function.<br /><br />I would have deployed following formula in situation like yours<br /><br />=IF(COUNT(E9:N9)&lt;5,SUM(E9:N9),(SUMPRODUCT(LARGE(E9:N9,ROW(1:5)))))<br /><br />I hope this helps, let me know in case you need further help<br />RegardsYogesh Guptahttp://www.blogger.com/profile/08246342663404873564noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-1914062024310046922010-04-30T07:13:02.925+05:302010-04-30T07:13:02.925+05:30What if all the cells in your data range don&#39;t have data yet? is there a way to only total the ones that are there up to a certain number? I tried using something like =SUMPRODUCT(LARGE(E9:N9,ROW(INDIRECT(&quot;1:B2&quot;))))<br />where B2 is a cell containing =COUNTIF(E9:N9,&quot;&gt;0&quot;) to count how many data points exist at this point.SmprFidelshttp://www.blogger.com/profile/14098426782190303802noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-43272262982256646032010-02-13T08:14:19.853+05:302010-02-13T08:14:19.853+05:30Hello kemas<br /><br />Thanks for your inpputs. I use sumproduct as workaround to enter CSE(Array) Formulas. The problem with the CSE formulas is exactly the same as you made mistake while writing this comment. In case user does not enter it with Ctrl+Shift+Enter it does not work.<br /><br />Problem gets compounded when some one using your worksheet tries to modify your CSE formula. If that user is not aware of CSE formulas, he will never figure out why the formula stoped working.<br /><br />Just write Sumproduct(Your CSE formula) all these issues disappear<br /><br />ThanksYogesh Guptahttp://www.blogger.com/profile/08246342663404873564noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-32173166928539817742010-02-13T01:24:39.061+05:302010-02-13T01:24:39.061+05:30sorry!<br />Ctrl +Shift+ Enterkemashttp://www.blogger.com/profile/08699660334015956023noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-78218727600395981412010-02-13T01:23:38.118+05:302010-02-13T01:23:38.118+05:30we can use<br />=SUM(LARGE(Data;ROW(1:5)))<br />and click<br />Ctrl + Enterkemashttp://www.blogger.com/profile/08699660334015956023noreply@blogger.com