1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Help required with Excel adding letters in columns

Discussion in 'Business Applications' started by exceller, Oct 2, 2005.

Thread Status:
Not open for further replies.
Advertisement
  1. exceller

    exceller Thread Starter

    Joined:
    Dec 2, 2003
    Messages:
    389
    Help please.

    I've done a excel spreadsheet, where across the sheet in a line with maybe a few letters 'x' or 'H' or 'BH' and the next line will have the same. This could be from line 8 to line 121.

    But in a column say 'T8' to 'T121' I want to count the total number of 'x's in that column, also 'H' and 'BH' giving the total individually. ie:- x=3 H=6 BH=4 for column 'T' and the same with the other columns.

    Can this be done, please.
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,628
    First Name:
    Wayne
    you could do a count in seperate columns

    so
    in A1
    put
    =COUNTIF(T8:T121, "X")
    in A2
    =COUNTIF(T8:T121, "H")
    in a3
    =COUNTIF(T8:T121, "BH")
     
  3. exceller

    exceller Thread Starter

    Joined:
    Dec 2, 2003
    Messages:
    389
    Thanks ETAF, worked perfectly.
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,628
    First Name:
    Wayne
    Your Welcome. (y)
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/403964

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice