ExcelBanter - How do I enter a SUM(cell:cell) in pocket excel so it works prope.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I enter a SUM(cell:cell) in pocket excel so it works prope. (https://www.excelbanter.com/excel-worksheet-functions/12382-how-do-i-enter-sum-cell-cell-pocket-excel-so-works-prope.html)

How do I enter a SUM(cell:cell) in pocket excel so it works prope.

The regular type of SUM function does not appear to work in pocket Excel.
For example SUM(E3:E15) does return the sum of all the cells between E3 and
E15 but only the sum of E3 and E15.

I don't have Pocket Excel, but I really don't believe that what you say is
true. Are you sure you didn't type the formula =SUM(E3,E15), i.e. with a comma
instead of a colon?

On Wed, 9 Feb 2005 11:11:04 -0800, "WillyJ1000"
wrote:

The regular type of SUM function does not appear to work in pocket Excel.
For example SUM(E3:E15) does return the sum of all the cells between E3 and
E15 but only the sum of E3 and E15.

I have pocket pc and SUM works the same as in regular excel

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

"Myrna Larson" wrote in message
...
I don't have Pocket Excel, but I really don't believe that what you say is
true. Are you sure you didn't type the formula =SUM(E3,E15), i.e. with a
comma
instead of a colon?

On Wed, 9 Feb 2005 11:11:04 -0800, "WillyJ1000"
wrote:

The regular type of SUM function does not appear to work in pocket Excel.
For example SUM(E3:E15) does return the sum of all the cells between E3
and
E15 but only the sum of E3 and E15.