# Total amount if month is januari

1. ## Total amount if month is januari

Hello,

I have a table with some colums.
A1 to A10 : date (normal date format xx/xx/xxxx)
E1 to E10 : amount

For K5 I need a formula that makes a total amount for the records with a date in januari.

Many thanks.

2. ## Re: Total amount if month is januari

Hi

One way

With January 1st in say F1

Formula:
`Please Login or Register  to view this content.`

Or you could use a pivot table

3. ## Re: Total amount if month is januari

Why should I add a second colum with the date ?
In the A colum are the dates.
Maybe I wrote it wrong, but what I need is a formula for cell K5 that makes the total of the amounts in colum E if the date in colum A is in januari.

See picture.
example.jpg

4. ## Re: Total amount if month is januari

I dont think Richard is suggesting you have a new column, he is saying that he put your criteria date in F1 - you could put the date anywhere, just adjust the forumla accordingly

5. ## Re: Total amount if month is januari

Solution found with a matrix formula.
There is a compatibility problem in Exell entering an english formula into an excel sheet of another language.
For the Dutch Exell this would be :
=SOM((maand(A2:A100)=1)*(B2:B100)) : It makes the sum of values in comumn B where the month is january in comumn A.
For English version of Excel it could be : =SUM((month(A2:A100)=1)*(B2:B100))

Because this is a matrix formula : do not enter the formula just with "enter". Enter it by pressing "CTRL/SHIFT/ENTER"

It works like a charm.

Question : is there a solution to make Excel 2013 of different languages compatible for entering formulas ? In the far past this was no problem.

6. ## Re: Total amount if month is januari

@Octonet

Another solution => use an pivot table.

7. ## Re: Total amount if month is januari

@Octonet,

Try SUMPRODUCT and Enter only:

=SUMPRODUCT((MONTH(A2:A100)=1)*E2:E100)

Or SUMIFS:

=SUMIFS(E2:E100,A2:A100,"<="&"31/01/2015",A2:A100,">="&"01/01/2015")

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