Excel: Sum of income by month - formula error
I have a excel document that I use to do my accounting.
On the first sheet I have a table that should display the income by month. The details for this table should be pulled from another worksheet in the same document.
What I want to do is to be able to auto-detect the income for each month. This means, that I would have a list of dates and an amount for that date in the corresponding row. I then want to have excel to automaticly detect the income for each month.
I found a formula that I modified, but it does throw an error that I am not able to solve. I hope somebody would take a look and give some advice.
In the attached file:
The first table 'Omsætning' should show the total income for the corresponding month. The values should be pulled from the worksheet named 'Omsætning'. If you look at the column for 'Jan (January)', you will see the formula that does not work.
Thank you for your advice!
I think I will post the formula here too, just in case the error is easy to spot:
I think I solved the issue. The formula was correct, however, because it is an array formula I had to create it by hitting CTRL + SHIFT + ENTER instead of just enter. Solution found on this page: http://www.ozgrid.com/forum/showthread.php?t=68280
|All times are GMT +1. The time now is 04:54 AM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.