Formula for Google tables
One has this kind:
Customer address delivery date
03.01.2021 13:51:063733Zach Wolfson USA 9975 Wadsworth Parkway K-2 #193 Westminster, CO 80021
03.01.2021 14:09:474471WardaSaudi Arabia Jeddah, AR Rabwah District 3
03.01.2021 14:20:374830Myron GochnauerCanada 100 Eaglewood Dr. Hanwell, NB E3E 2K6
03.01.2021 14:54:102203Kolby Thomas 5404 Summer Meadows Dr Fort Worth, TX 76123 United States
03.01.2021 15:10:427255Asap Blend - Mehdy Larriere12 rue Battant 25000 BESANÇON France
03.01.2021 15:42:375400Danny Chiam Klinik Kesihatan Dr Chiam, No.112, G/F, Kota Padawan, Jalan Penrissen Kuching Sarawak 93250 Malaysia
03.01.2021 15:44:36880michael murray 75 Cabot St Apt 8 beverly MA 01915-4979 United States
03.01.2021 15:46:35880Marios KalantzakisKassandrou 42 Thessaloniki 54633 Greece
03.01.2021 15:48:531610kevin warner 1607 landau rd Jacksonville FL 32225-8280 United States
The second such
the country.United States1010000United Kingdom
Canada
France
Italy
Germany
Spain
Australia
Japan
India
You need to write the formulas for the second table that will look for the country in the address of the first table and make such lines count, as well as count the total amount of these lines.That is, it is necessary to count the number of orders per country and their total amount.The tables are in one document on different sheets.You have to do it on your table and show the result.
-
1115 109 0 Good day Maxime.
I specialize in the development of script for Google tables.
Please drop the link. I can do it now.
-
1098 225 11 8 Good day Maxime.
I will be happy to accomplish your task.
Prepared to begin immediately after the discussion and approval of the details of the project.
Let us collaborate!
Current freelance projects in the category Desktop Apps
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 1 day 12 hours back ∙ 10 proposals |
Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food)
23 USD
We are looking for an experienced team or a Middle/Senior Android developer (possibly with Full-stack skills) to create proprietary software for self-service kiosks for a fast food retail chain. Currently, our terminals operate on a ready-made cloud integrator, but we are… Content Management Systems, Desktop Apps ∙ 6 days 8 hours back ∙ 23 proposals |
It is necessary to migrate the current working program from FoxPro to C#.Hello everyone! We have a program in FoxPro (it has several modules, it's an accounting program), we have the source code of the program, and if necessary, we can consult with people who support the current program. What needs to be done: 1. Analyze how everything works,… C#, Desktop Apps ∙ 11 days 16 hours back ∙ 19 proposals |