1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Sum formula not working

    From SAM HO@21:1/5 to All on Wed Sep 2 07:49:50 2020
    On Google Docs, I use the formula =sum(E29:F29) press enter, result = 0
    Always, any reason why?
    Help please.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Auric__@21:1/5 to SAM HO on Thu Sep 3 04:48:42 2020
    SAM HO wrote:

    On Google Docs, I use the formula =sum(E29:F29) press enter, result = 0 Always, any reason why?
    Help please.

    (Google Docs is *not* Excel.)

    Without seeing your spreadsheet, we can't diagnose the problem. My first thought is that you have numbers entered as text.

    --
    Base not your joy on the deeds of others,
    for what is given can be taken away.
    -- Peter Steele

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)