Excel. My formula does not work. I tried to use a formula of the website https://exceljet.net/formula/sum-by-month How I kan make sums per month (on the right side of the image)? The excel-sheet is downloadable via the following wetransfer-link: https://we.tl/BYFkdQFxWi
MFeG9IJ.png
Try
F4Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Cool, that helps! Now, I am trying to sum it by month and year.
=SUMPRODUCT((TEXT($B$4:$B$9;"MMMM/YYYY")=E4)*($C$4:$C$9))
This formula did not work (excel beginner experience). What do I have to change in the formula?
Screen Shot 2017-02-27 at 08.36.33.png
But here it is working good.Originally Posted by floris3000
Please check the attached file.
I see I cannot add reputation in one post twice.
Thanks for feedback and rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks