ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sum-large on excell mobile (pocket PC) (https://www.excelbanter.com/excel-worksheet-functions/129288-sum-large-excell-mobile-pocket-pc.html)

tom

Sum-large on excell mobile (pocket PC)
 
I am trying to write a function that is "=SUM(LARGE(C2:C12,{1,2,3}))" for
excel mobile but keep getting error. Does anyone have a function to take the
sum of the three largest numbers in a column? Or a way to modify my function
to achieve this in excel mobile.

Dave F

Sum-large on excell mobile (pocket PC)
 
This works on regular excel. What error are you getting?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Tom" wrote:

I am trying to write a function that is "=SUM(LARGE(C2:C12,{1,2,3}))" for
excel mobile but keep getting error. Does anyone have a function to take the
sum of the three largest numbers in a column? Or a way to modify my function
to achieve this in excel mobile.


tom

Sum-large on excell mobile (pocket PC)
 
I get the Error message as follows:

'Error in formula. There may be an incorrect number of arguments, a missing
operand or parenthesis, or another syntex error.'



"Dave F" wrote:

This works on regular excel. What error are you getting?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Tom" wrote:

I am trying to write a function that is "=SUM(LARGE(C2:C12,{1,2,3}))" for
excel mobile but keep getting error. Does anyone have a function to take the
sum of the three largest numbers in a column? Or a way to modify my function
to achieve this in excel mobile.



All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com