Sum If Function

[fish22]

Hey guys,
I am trying to set up a basic accounting spreadsheet and have hit a dead end. Have been trying for ages to try and get this working.
As part of the report needed by my client, there needs to be a sum off all purchases and expenses that are capital, and then non capital. As part of the monthly transaction input there is a cell for the account of the transaction.
I have set up a named range with all of the capital accounts, and all of the non-capital accounts. What I am trying to do is sum the transaction ammount if it is in the named range. The sum if function isnt working as, I have been told because the named range is strings and not integers. I am not the best at VBA so would love to do it avoiding it.
Thanks for any help guys.

 

[Trevor G]

Welcome to the forum,

Can you copy part of the spreadsheet into your thread to give us an idea of what you are using and also make some sort example how it should look, if it is just totals based on values and capital against non-capital SUMIF should work.

But please show some data.

 

[Aladin Akyurek]

Hey guys,
I am trying to set up a basic accounting spreadsheet and have hit a dead end. Have been trying for ages to try and get this working.
As part of the report needed by my client, there needs to be a sum off all purchases and expenses that are capital, and then non capital. As part of the monthly transaction input there is a cell for the account of the transaction.
I have set up a named range with all of the capital accounts, and all of the non-capital accounts. What I am trying to do is sum the transaction ammount if it is in the named range. The sum if function isnt working as, I have been told because the named range is strings and not integers. I am not the best at VBA so would love to do it avoiding it.
Thanks for any help guys.

Try to post a tiny, illustrative (fake) sample along with the desired results.

 

[fish22]

Heres a sample of the report:

And the Input sheet

 

[fish22]

Ooops, heres the report:

 

[fish22]

Anyone?

 

[Trevor G]

Looking at your examples I still don't see what is capital and non-capital.

Do you have multiple sheets One per month that you are using like a ledger and how do you determine what is capital and non-capital?

 

[fish22]

Oh sorry, yeah I've got a sheet for each month, which I input the data, then a sheet for the statement, and another sheet for the chart of accounts like this;

Thanks heaps.