M
M
Marat Akhmetshin2021-09-01 10:37:00
Google Sheets
Marat Akhmetshin, 2021-09-01 10:37:00

How to form a list of values ​​according to a condition?

There is a bank statement (SberBusiness). It is located in a separate tab and statements from different accounts are aggregated there. It is necessary to withdraw transfers made from a certain account, or vice versa to a certain account, and accordingly sum up how much and where and what. How to do it?
As an option, I know there is a unique() formula that outputs unique values, but there will be many zeros and a long list. How to display values, where there will be rows that belong to only one account, that's the difficulty.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-09-01
@bukrat

You need FILTER ()

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question