spreadsheet help (adding complex columns)

Discussion in 'Mac Apps and Mac App Store' started by howard, Jan 8, 2010.

Most Liked Posts
  1. howard, Jan 8, 2010

    howard macrumors 68020

    howard

    Joined:
    Nov 18, 2002
    #1
    Got a question for you spreadsheet gurus. I'm no good at this stuff...

    I have 2 columns. Column A is a range of numbers. Column B is a specific word relating to the number of the same row of Column A.

    I want to make an equation to add all the numbers in Column A if the word in Column B equals ... whatever I want it to be. Here's an example of the data:

    A B

    3 red
    6 green
    2 red
    7 red
    2 green
    4 blue

    And here is the outcome I want... Add all red = 12. Add all green = 8. Add all blue = 4
     
    share
    + Quote Reply
  2. Gregg2, Jan 8, 2010

    Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #2
    Well, I don't know, but the answer is gonna depend on which application you're using, and maybe what version. That is, unless Edgar Cayce is a member here and happens to read this. ;)
     
    share
    + Quote Reply
  3. CMelton, Jan 8, 2010

    CMelton macrumors regular

    CMelton

    Joined:
    Dec 8, 2008
    Location:
    London, UK
    #3
    What program are you using?

    In Numbers from the iWork suite there is a function called SUMIF (There is probably one in Excel too if that's what you are using).

    Check out the Function Browser under

    Insert >>Function>> Show function browser

    and search for SUMIF.

    It'll give you exactly what you need, sorry I don't have time to type it all out :)

    Hope this helps.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page