Hey guys,
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!
EDIT:
I think I will post the formula here too, just in case the error is easy to spot:
Code:
=SUMPRODUCT(IF(ISBLANK(Omsætning!B8:B206);0;1);--(MONTH(Omsætning!B8:B206)=MONTH(B9));--(YEAR(Omsætning!B8:B206)=YEAR(B9));Omsætning!E8:E206)
Kind regards,
Before you post, read our: 
