Summarising Data – adding totals if condition met

[pauldaddyadams]

Hi,

I have a dataset in a table which I would like to summarise into a much smaller table based on the following:

1. If there is a value in column J then I would like the whole row returned to the new summary table.
2. Then I would like just a summary of the totals for the credits.

Ideally I would like this to be all self populating

Is that possible? anyone know how I can achieve this? Any suggestions are welcomed.

I have included an example which illustrates what I need (the green cells need to be replaced with formulas).

[pauldaddyadams]

I made a bit of progress with this but I am still stuck.

In columns AE:AO I have formulas which pull the data ok for the first item on the list (214140) but I now need it to loop through to the next GL automatically.

How can this be done?

[pauldaddyadams]

Hi, can anyone help with this? Or if anyone has anything similar I will try and work it out from that

[pauldaddyadams]

Hi all,

I've had no one pick this up?

Can this even be done?

If there is a mod reading this can you post it in the call in the Caverely section please?

[bebo021999]

I'd like to ask u some question?
1) Can we use 5 helper columns , A to E column? to create lookup_value to draw data into G/L acc debit book.
2) I am accountant too. I usually to draw G/L book into separate sheet and use dropdown list to choose active G/L acc. It is so complicated to mix all G/L acc into one table, one after one.
3) Do you need to create Balance sheet after that?

[pauldaddyadams]

Hi

Helper columns can be used, anything can be done to achieve what I need.

What I have is the first few columns drawing from another sheet which would create a debit and credit for each line item. This is in the format of a journal template so all o have to do is upload it

The reason for my post is because it creates a fb/cr for every line item it will create thousands of entries which I want to avoid

Ideally I would like in the green cells for the format to be kept and then only the debits listed and then just the total of the credit items.

Regarding the balance sheet, this isn't needed. What I'm creating is the journal to post to p&l and balance sheet

[bebo021999]

Just give it a start. I am stuck at credit account publishing after each debit account(lines 24,25).
Called for helps already. Hope anyone jump in and give valued advice.

[davesexcel]

What's the purpose for this?

[pauldaddyadams]

Hi

I get a report which lists all sales, it's transactional data.

What I then need to do is account for each transaction by debiting/credit certain GL control accounts.

I have it working where posts a debit and credit for each line item but ideally I would only like to post the debit entries and just the total for the credits.

This formula is on the template sheet. It's this sheet which will be uploaded into SAP to post the entries.