+ Reply to Thread
Results 1 to 4 of 4

Adding cells that also contain letters

  1. #1
    Registered User
    Join Date
    04-06-2018
    Location
    SEATTLE
    MS-Off Ver
    MICROSOFT OFICE 365 HOME EDITION
    Posts
    1

    Adding cells that also contain letters

    I'm try to sum up the total on the excel spreadsheet i'm making

    row a1 A6 row B1 S6 row C1 CS6 how can add these

    Thank you

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,726

    Re: Adding cells that also contain letters

    What result would you expect after adding those three cells?

    Pete

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Adding cells that also contain letters

    I know.

    The answer is A6+S6+CS6 !

    The above can't be correct, so you must be wanting some indirect function here? Perhaps
    Indirect("A1")+Indirect("S6")+Indirect("CS6")
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Adding cells that also contain letters

    Do you mean this?

    =SUM(B1:B6,C1:C6,CS1:CS6)

    What do you mean by "that also contain letters"? You are going to need to offer a lot more specific detail. We are not mind-readers.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding Sums To Cells Containing Letters and Numbers
    By Gtrtim112 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2017, 07:27 PM
  2. [SOLVED] Adding cells that contain letters & numbers
    By Gtrtim112 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-27-2013, 03:22 PM
  3. Adding letters with numbers
    By zingas10 in forum Excel General
    Replies: 3
    Last Post: 01-30-2013, 10:06 AM
  4. adding cells with letters and numbers
    By stryped in forum Excel General
    Replies: 3
    Last Post: 12-02-2011, 10:36 AM
  5. Replies: 9
    Last Post: 07-15-2010, 08:54 PM
  6. Adding Greek letters
    By tmac98 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2008, 04:25 PM
  7. Adding letters and numbers
    By TH3ROOKIE in forum Excel General
    Replies: 3
    Last Post: 09-21-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1