# 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.  Register To Reply

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  Register To Reply

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  Register To Reply

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  Register To Reply

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.  Register To Reply

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

@Octonet

Another solution => use an pivot table.  Register To Reply

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")  Register To Reply