# A formula to return values for financial statements isn't working

1. ## A formula to return values for financial statements isn't working

(I'm Dutch, so sorry for spelling mistakes and/or unclear statement about the code)

I want to put together a financial oversight or balance sheet for myself so that I can keep my income and spendings in check. I found a formula in an already existing spreadsheet made by a business, but they only had a spreadsheet on a yearly basis, whilst I want to have a spreadsheet seperated into different tabs(every tab being a different month) with my day to day income and spendings.

The original formula is:

=-IF(ISBLANK(\$F14);;SUM.IFS(Transacties!\$E:\$E;Transacties!\$B:\$B;\$F14; ARRAYFORMULA(MONTH(Transacties!\$C:\$C));MONTH(H\$4)))

Transacties!\$E:\$E refering to the column of amount of the transactions in euro's in the transactions tab.

Transacties!\$B:\$B refering to the column of types of transactions (e.g. income, repairs, travel costs).

\$F14 in the balance tab refering to the type of transaction to compare if it matches up with the transactions tab.

Transactions!\$C:\$C is the date given in the transactions sheet

and probably kinda obviously H\$4 in the balance tab is to compare it to the transactions tab.

My formula is as follows:

=-IF(ISBLANK(K\$2);;SUM.IFS(Transacties!\$D:\$D;Transacties!\$C:\$C;K\$2;ARRAYFORMULA(DATE(Transacties!\$E:\$E));DATE(\$K4)))

In my sheet Transacties!\$D:\$D is the amount.

Transacties!\$C:\$C the type of transaction.

K\$2 the comparator.

Transacties!\$E:\$E the date.

\$K4 the comparator for the date.

But upon trying out my formula it's telling me "Matrixarguments for SUM.IFS have different sizes"

Thanks in advance, I've been trying to figure it out on my own, but I can't for the life of me.

I've posted this on another forum and r/spreadsheets as well and I got referred to this site. I know it's spreadsheets and not Excel, but I was hoping someone could help me either way

2. ## Re: A formula to return values for financial statements isn't working

Flame_Bird

Attached reworks your Jan and Feb sheets to show Income and Expenditure for each month.

Cols B - D show the Income, Cols E - O your outgoings in thier different Categories.
If you have multiple costs or incomes on the same day, just add extra rows with the same dates. It does not matter how many rows you use for different months.
Opening Balance each month is linked to the Closing Balance of the month before. (Jan has a dummy Opening value of 5000).

Rows 41 - 48 show what you earned and spent in each Category in the month, and whether you over spent or saved anything.

Hope this helps.

Ochimus

3. ## Re: A formula to return values for financial statements isn't working

Thanks for helping me out! My problem's been solved. I really appreciate you taking your time to help me out, have a wonderful day!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1