| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lost all excell files | Excel Discussion (Misc queries) | |||
| Having Trouble with the RANK Function...Try LARGE or SMALL Functio | Excel Worksheet Functions | |||
| Keyboard shortcuts for time in Pocket Excel | Excel Worksheet Functions | |||
| How to convert excel Docs to pocket excel on my mobile device | New Users to Excel | |||
| lable ranges in Excell | Excel Discussion (Misc queries) | |||
Linear Mode
