+ Reply to Thread
Results 1 to 8 of 8

Hard? SUM the values of a column that matches a flag in an adjacent column

  1. #1
    Registered User
    Join Date
    01-07-2012
    Location
    Venezia
    MS-Off Ver
    Google Docs ^_^
    Posts
    5

    Hard? SUM the values of a column that matches a flag in an adjacent column

    Hi !

    I try to make a table here ...:
    Please Login or Register  to view this content.
    I need to sum VALUES of a certain trimester (1 2 3 or 4)
    So I have something like:
    Sum of trimester 1: 45
    Sum of trimester 2: 81
    Sum of trimester 3: 20
    Sum of trimester 4: 16

    I'm getting crazy with LOGIC and SEARCH functions and I don't know how to solve this ...
    The next step will be to search into a DATE RANGE instead of 1-2-3-4 ... but I actually want to start from the easy part.
    Last edited by Nokao; 01-07-2012 at 11:33 AM. Reason: solved

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,395

    Re: Hard? SUM the values of a column that matches a flag in an adjacent column

    Hi Nokao and welcome to the forum,

    Try a Pivot Table.

    What version of Microsoft Excel are you using?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Hard? SUM the values of a column that matches a flag in an adjacent column

    Or maybe use SUMIF()
    e.g.
    Please Login or Register  to view this content.
    Drag down as required

    ROW(A1) returns 1 and as it is dragged down it increments by one .... so 1,2,3, etc
    You can replace ROW(A1) with a specific cell reference if you want or need to.
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  4. #4
    Registered User
    Join Date
    01-07-2012
    Location
    Venezia
    MS-Off Ver
    Google Docs ^_^
    Posts
    5

    Re: Hard? SUM the values of a column that matches a flag in an adjacent column

    Quote Originally Posted by MarvinP View Post
    Hi Nokao and welcome to the forum,

    Try a Pivot Table.

    What version of Microsoft Excel are you using?
    Hi !
    Thanks for the very fast answer.

    I have to manage to do this on Google Documents, but before that I want to make it in excel that is more complete. I use Open Office 3.3 at home. Is that ok ?

  5. #5
    Registered User
    Join Date
    01-07-2012
    Location
    Venezia
    MS-Off Ver
    Google Docs ^_^
    Posts
    5

    Re: Hard? SUM the values of a column that matches a flag in an adjacent column

    Quote Originally Posted by Marcol View Post
    Or maybe use SUMIF()
    e.g.
    Please Login or Register  to view this content.
    Drag down as required

    ROW(A1) returns 1 and as it is dragged down it increments by one .... so 1,2,3, etc
    You can replace ROW(A1) with a specific cell reference if you want or need to.
    Thanks ! Great !
    This forum is so alive

  6. #6
    Registered User
    Join Date
    01-07-2012
    Location
    Venezia
    MS-Off Ver
    Google Docs ^_^
    Posts
    5

    Re: Hard? SUM the values of a column that matches a flag in an adjacent column

    If I have a "WHEN" date format instead of a "trimester" column, will this work?

    Please Login or Register  to view this content.
    Last edited by Nokao; 01-07-2012 at 10:46 AM.

  7. #7
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Hard? SUM the values of a column that matches a flag in an adjacent column

    You are now probably going to have to think in terms of SUMPRODUCT()
    Please Login or Register  to view this content.
    See this link for information and examples of functions supported by Open Office
    Calc Functions listed by category
    Attached Files Attached Files
    Last edited by Marcol; 01-07-2012 at 11:24 AM.

  8. #8
    Registered User
    Join Date
    01-07-2012
    Location
    Venezia
    MS-Off Ver
    Google Docs ^_^
    Posts
    5

    Re: Hard? SUM the values of a column that matches a flag in an adjacent column

    Quote Originally Posted by Marcol View Post
    You are now probably going to have to think in terms of SUMPRODUCT()
    Please Login or Register  to view this content.
    See this link for information and examples of functions supported by Open Office
    Calc Functions listed by category
    Can't check this now on Google Documents, but it works on Open Office !

    Thank you very much, I'm putting this on "resolved".

+ 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