Closed

Google sheet query

I use google sheet tables in which I fill in multiple "databases". I use data from databases to structure them with a google sheet and use them for reports. The existing formula I use to get my data out is: = if ($ B $ 1 = "Payment"; query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '" & $ A $ 1 & "'and B =' Output invoice 'order by'" & $ F $ 1 & "'"; 0); query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '"& $ A $ 1 &"' and (B = 'Construction site - situation / invoice' or B = 'Invoice' or B = 'Offer / proforma invoice') order by '"& $ F $ 1 &"' "; 0)).

it needs to be refined to automatically summarize projects by summing up an individual project and providing data according to a formula. An example is in the task file. Eg. it is necessary to summarize the "Daruvarske toplice" project and the "Lipik specijalna bolnica" project. Picture "tablica e" is current state, and picture "tablica e new" is future state. Formula must be in quary form as current.

Skills: Excel, Data Processing, Data Entry, Google Sheets, Excel Macros

See more: custom reports in google analytics let you do which of the following?, combine tables from multiple sheets in the same workbook with power query, power query append multiple tables, power query merge multiple tables, google sheets query multiple sheets, google sheets query select multiple columns, google sheets query multiple criteria, google sheets query another sheet, mysql query examples multiple tables, custom reports in google analytics let you do which of the following, case studies on the safety management at construction site, google sheets query multiple sources, google sheet api query, update query with multiple tables, google sheets query multiple ranges, link google sheet to big query, which option gives us choice to open the tables forms and reports, which of the following google sheet formulas are related to the web?, google sheet formulas are related to the web, google sheets query((importrange multiple sheets))

About the Employer:
( 0 reviews ) Croatia

Project ID: #30538184

17 freelancers are bidding on average €28 for this job

(440 Reviews)
8.3
(63 Reviews)
6.3
IgeS

Hi there, You want to have the Query formula modified? You need a new group "New Project" and the sum of each groups added in the Query formula? Please message me if this is any of what you need. I'll be standing by More

€40 EUR in 1 day
(39 Reviews)
5.3
AnuradhaVM

Hi, Greetings! ✅checked your project details. I can build google sheet query. I Have 4 years of experience with Data entry, Data analysis, and MIS Management. I have Power BI and Excel/google sheet skills and am able t More

€30 EUR in 2 days
(30 Reviews)
4.5
Monirulop

Hi, I am ready to start right now. I can help you with your project according to your requirements. I am interested in your project. I ensure I will complete the task successfully and within the specified time. I love More

€30 EUR in 1 day
(23 Reviews)
4.0
(28 Reviews)
3.8
ArioNugroho

Hello, I can help you with this project. From what I understand you want the query to show summaries of multiple projects. I'm pretty sure I can do this job for you. I have created many google sheet files and excel fi More

€30 EUR in 3 days
(6 Reviews)
3.1
irwantocirebon

I've been craving this for a long time, this job suits me perfectly, because I'm the best at writing and editing data professionally

€19 EUR in 7 days
(0 Reviews)
0.0
purohitdheeraj75

Hello I have 4 years of experience in this field IL do my work neat and clean and also my speed is very good so do select me for this work

€19 EUR in 7 days
(0 Reviews)
0.0
SPKarthik95

Hi, I have read your job description and will work as per your requirement within time.

€19 EUR in 7 days
(0 Reviews)
0.0
gurunathguru

I can complete your project as you need i.e. today because I have an experience of 3 years in this field and my main business is data entry.

€19 EUR in 7 days
(0 Reviews)
0.0
crnithinkumar

I'm a Data Analyst, Who can work on Excel with full knowledge and i'm a certified Microsoft Excel Expert which can help you in cutting down the project timing and i can help you with implementing easier technique to si More

€22 EUR in 7 days
(0 Reviews)
0.0
vermaaakash311

Hi there, I am expert in Web search, Research, Market Research, Lead Generation, Web Scraping and Data Entry. Lets have a quick chat on this project to clear further details.

€25 EUR in 7 days
(0 Reviews)
0.0
gouravkashyap293

I will deliver your project in time and there will not be delay in my work. I assure that you will like my work. I am here for long term work relationship so will give 101% best output from my end so that you consider More

€19 EUR in 7 days
(0 Reviews)
0.0
AwasthiVaibhav

Hello, I have fully understood your requirement and went into details of your input and required output file. I have several years of experience in working with excel and am a established programmer. I am new to freela More

€10 EUR in 1 day
(0 Reviews)
0.0
digveshkmr1

I am expert in this work because I am doing this since 2016. so, please give a chance to doing this.

€19 EUR in 7 days
(0 Reviews)
0.0
lihansalk15

Hello dear client, Thanks for posting the job. I went through your job carefully and wish to inform you that I'm very much glad to accept this job which matches with my potential. Please find below my skills and stan More

€12 EUR in 1 day
(0 Reviews)
0.0