Sum-large on excell mobile (pocket PC)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 05 Feb 2007 16:26 GMT

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 to this Message

Dave F - 05 Feb 2007 21:02 GMT

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

Dave

Signature

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

> 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 to this Message

Tom - 06 Feb 2007 13:45 GMT

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.'

> This works on regular excel. What error are you getting?
>
[quoted text clipped - 4 lines]
> > sum of the three largest numbers in a column? Or a way to modify my function
> > to achieve this in excel mobile.

Reply to this Message