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.
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.
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
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thanks for the quick answer.
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
Last edited by Octonet; 01-16-2015 at 09:33 PM.
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
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
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.
@Octonet
Another solution => use an pivot table.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
@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")
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks