+ Reply to Thread
Results 1 to 7 of 7

Mutli-column Formula

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    London, England
    MS-Off Ver
    Excel 97-2004
    Posts
    4

    Mutli-column Formula

    Hey guys,

    Need some help writing the following formula.

    Sum of cells with value "X" in column A and value "Z" in column F.

    The cells must have the needed value in both columns in order to be included in the total sum.

    Is this doable?

    Let me know if you need more information.
    Last edited by btwc; 05-21-2013 at 05:23 PM.

  2. #2
    Registered User
    Join Date
    05-21-2013
    Location
    London, England
    MS-Off Ver
    Excel 97-2004
    Posts
    4

    Re: Mutli-column Formula

    Actually, now that I think about it, it might be the sum of rows with value "X" in column A and value "Z" in column F.

    Does that make more sense?

  3. #3
    Registered User
    Join Date
    10-27-2012
    Location
    London
    MS-Off Ver
    Excel 2007-2010
    Posts
    59

    Re: Mutli-column Formula

    Hi btwc,

    Initially I thought you may be after the excel formula sumifs

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    where the values you want to sum are in range B1 to B20 in this example. However you are referring to summing a row in your second post.
    Break_Point

  4. #4
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: Mutli-column Formula

    Are you looking to see how many times each value shows up (counting)? Or are you looking for the sum of every value?

    If you're looking for the count try this formula =SUM(COUNTIF($A:$A,"X"),COUNTIF($F:$F,"Z"))

    If you're looking for the sum try this one =SUM(SUMIF($A:$A,"X",$A:$A),SUMIF($F:$F,"Z",$F:$F))

  5. #5
    Registered User
    Join Date
    05-21-2013
    Location
    London, England
    MS-Off Ver
    Excel 97-2004
    Posts
    4

    Re: Mutli-column Formula

    Here's some more information:

    My spreadsheet covers 6,000 rows.

    I want to know the total number of assets within that spreadsheet that have the value "X" in column A AND the value "Y" in column F. They have to meet both the "X" and "Y" criteria to be included in the sum I'm looking for.

  6. #6
    Registered User
    Join Date
    10-27-2012
    Location
    London
    MS-Off Ver
    Excel 2007-2010
    Posts
    59

    Re: Mutli-column Formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This formula will count how many assets have both the criteria X in column A and Z in column F.

  7. #7
    Registered User
    Join Date
    05-21-2013
    Location
    London, England
    MS-Off Ver
    Excel 97-2004
    Posts
    4

    Re: Mutli-column Formula

    That's exactly what I was looking for!

    Thanks so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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