+ Reply to Thread
Results 1 to 8 of 8

Help counting the sum of cells containing letters

  1. #1
    Registered User
    Join Date
    04-07-2021
    Location
    England
    MS-Off Ver
    365
    Posts
    4

    Help counting the sum of cells containing letters

    I'm trying to compile a simple holiday chart and have a specific cell return a value for a range of cells in a column above containing H as 1 and h as 0.5. I've tried using COUNTIF or COUNTIFS, but I can't get the result I need. Any ideas what I could try?

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,351

    Re: Help counting the sum of cells containing letters

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Registered User
    Join Date
    04-07-2021
    Location
    England
    MS-Off Ver
    365
    Posts
    4

    Re: Help counting the sum of cells containing letters

    I've uploaded a file called Sample Problem if that helps
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    02-09-2021
    Location
    New York
    MS-Off Ver
    Office 2019
    Posts
    145

    Re: Help counting the sum of cells containing letters

    Hi steve,

    Countif is not case sensitive.
    Please try:
    Please Login or Register  to view this content.
    Hope this is what you are looking for.

  5. #5
    Registered User
    Join Date
    04-07-2021
    Location
    England
    MS-Off Ver
    365
    Posts
    4

    Re: Help counting the sum of cells containing letters

    Thank-you so much, that is exactly what I was trying to do.

  6. #6
    Registered User
    Join Date
    04-07-2021
    Location
    England
    MS-Off Ver
    365
    Posts
    4

    Re: Help counting the sum of cells containing letters

    Just one more question if you don't mind. I'm assuming that the little green triangles in the cells containing this formula indicate that there's no data to count. Is there an easy way to suppress these?

  7. #7
    Forum Contributor
    Join Date
    02-09-2021
    Location
    New York
    MS-Off Ver
    Office 2019
    Posts
    145

    Re: Help counting the sum of cells containing letters

    Sorry, I don't know what causing that background error. I'm not getting that with the excel file you provided so I won't be able to determine the cause.

    You can try this code where I added an iferror (leaves a blank if it encounters an error):
    Please Login or Register  to view this content.

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    13,175

    Re: Help counting the sum of cells containing letters

    As to post #6. If you select the cells that have the green triangles (top left corner of cell) then a trace error button should display next to the active cell. In the right half of the trace error button is a drop down and one of the options is to "Ignore Error".
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] counting letters as numbers in many different cells ?
    By jeccobeard in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-03-2018, 04:32 PM
  2. counting letters as numbers in many different cells ?
    By jeccobeard in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2018, 09:57 PM
  3. [SOLVED] Counting cells because of 4 same letters in the cell
    By dontbugme1 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-26-2015, 02:11 PM
  4. Replies: 8
    Last Post: 07-23-2014, 09:12 AM
  5. [SOLVED] Help Counting Cells w/first 3 letters...
    By CRichardsDSX in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-31-2012, 09:47 AM
  6. Replies: 9
    Last Post: 07-15-2010, 08:54 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