Assist please - Excel formula

Discussion in 'General Chat' started by mate_pl, Jan 16, 2009.

0
  1. #1
    Hello DP!

    I have one big excel sheet and I need just one simple IF formula to make it easier for me to do some calculations.

    Here is what I need:

    column A: Text data, let's call it "textA" "textB" "textC"
    column B: numbers

    what I need is simple formula which calculates the following:

    results: textA=total textB=total textC=total

    total is taken out of column B, so textA=total is total number of textA's out of coumn B.


    Hope I haven't complicated this too much...


    Thank you!!!
     
    mate_pl, Jan 16, 2009 IP
  2. sachin410

    sachin410 Illustrious Member

    Messages:
    6,422
    Likes Received:
    573
    Best Answers:
    0
    Trophy Points:
    410
    #2
    it is complicated...:D.

    can you show us an example of what exactly you want?
     
    sachin410, Jan 16, 2009 IP
  3. fancymouj

    fancymouj Peon

    Messages:
    5,019
    Likes Received:
    134
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yes, you are right. I don't think it's possible.
     
    fancymouj, Jan 16, 2009 IP
  4. mate_pl

    mate_pl Active Member

    Messages:
    1,372
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    80
    #4
    I think I just complicated it by trying to explain. Please check it:

    [​IMG]

    All I need is to get the following to be calculated by one formula:

    field C8: total number of 4 (I have a's in fields B1 and B4 with values of 2 (field C1) and 2 (field C4)).
    field C9: total number of 5 (I have b's in fields B2 and B5 with values of 3 (field C2) and 2 (field C5)).
    field C10: total number of 4 (I have c's in fields B3 and B6 with values of 1 (field C3) and 3 (field C6)).
     
    mate_pl, Jan 16, 2009 IP
  5. sachin410

    sachin410 Illustrious Member

    Messages:
    6,422
    Likes Received:
    573
    Best Answers:
    0
    Trophy Points:
    410
    #5
    why don't you just sort the data in column B by alphabetical order and then add up using "AutoSum"?

    how many different types of data are there in column B?
     
    sachin410, Jan 16, 2009 IP
  6. mate_pl

    mate_pl Active Member

    Messages:
    1,372
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    80
    #6
    I am not sorting it in AZ order because the data is constantly updated in the bottom. Column B is always text data...

    I always summarize it manually by filtering it via Autofilter after which I just drag mouse through column C and get result, but now I want to make it automatized...
     
    mate_pl, Jan 17, 2009 IP