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.
Bu iş için 17 freelancer ortalamada €28 teklif veriyor
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 Daha Fazla
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 Daha Fazla
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
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.
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 Daha Fazla
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 Daha Fazla