1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • An Excel Question :-)

    From Physfitfreak@21:1/5 to All on Sun Apr 2 16:27:13 2023
    XPost: microsoft.public.excel

    How can one, without the use of VBA, sum over a range of cells some of
    which have number values inside and some text values (depicting a number)?

    Is there a function for that? If not, how do you successfully make your
    sum over that range of cells?

    --
    This email has been checked for viruses by Avast antivirus software. www.avast.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ammammata@21:1/5 to Physfitfreak on Mon Apr 3 09:45:11 2023
    XPost: microsoft.public.excel

    Physfitfreak wrote on 02/04/2023 :
    sum over a range of cells some of which have number values inside and some text values (depicting a number)?

    excel 2021 does it with the standard SUM()

    10
    '15
    26
    '38

    the SUM below these cells gives 36

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

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