G
G
gladyshef2019-03-29 16:10:00
Google Sheets
gladyshef, 2019-03-29 16:10:00

How to calculate the number of payments on different days automatically and multiply by the rule by the reward?

Brothers, help me out) There is a difficulty, how can I:
1) collect the number of payments per day in the table, but only in one cell so that the number of payments is shown, and not in each (if we count repeated dates) The solution with inserting it yourself into cell, it is necessary that the machine be considered throughout the list and only shown in one cell, so that later this number can be multiplied by the amount of remuneration.
2) after you have received the amount of payments per day, you need to make an account in another cell according to the rule, if the amount is greater than or equal to 3m (payments), then multiply by 300, if more than 3x then multiply by 200.
5c9e169264c2f193223851.png

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question