+ Reply to Thread
Results 1 to 4 of 4

Sum cells where another cell in the same row has a certain value

  1. #1
    Registered User
    Join Date
    09-12-2007
    Posts
    24

    Sum cells where another cell in the same row has a certain value

    Hi!

    I want to be able to total up the values in column A but only including the cells in that column which have a certain value in the adjacent cell (in column B).


    i.e. something like
    =SUM(A1:A100) WHERE B1:B100="SomeValue"

    ANy ideas?

    Cheers in advance!

  2. #2
    Registered User
    Join Date
    06-28-2007
    Posts
    69

    Re: Sum cells where another cell in the same row has a certain value

    =SUMIF(B1:B100,"SomeValue",A1:A100)

  3. #3
    Registered User
    Join Date
    01-07-2009
    Location
    amsterdam
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Sum cells where another cell in the same row has a certain value

    I think you are looking for the sumif formula ?
    In your example the formula looks like this:

    =sum.if(B1:B100;"some value";A1:A100)

    Note: since I am using a non english version I had to guess for the formula name sum.if and the "some value" can be a reference to a cell offcourse...

    Hope this helps !

  4. #4
    Registered User
    Join Date
    09-12-2007
    Posts
    24

    Re: Sum cells where another cell in the same row has a certain value

    Great! Now one other thing... can I add another criteria to that?

    i.e.
    =SUM(A1:A100) WHERE B1:B100="SomeValue" AND C1:C100=DateBetween(1/1/08 and 31/1/08)

    Thank again!
    Last edited by maff; 03-09-2009 at 04:56 PM. Reason: changed Bs to Cs in the Datebetween bit. Sorry!

+ 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