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

1. ## 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.

2. ## 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?

3. ## 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.

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

Originally Posted by MarvinP
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. ## Re: Hard? SUM the values of a column that matches a flag in an adjacent column

Originally Posted by Marcol
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. ## 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.``

7. ## 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

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

Originally Posted by Marcol
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".

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

#### 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