Find Jobs
Hire Freelancers

Create a Formula on Excel According to the Criteria Provided

$10-30 USD

Concluído
Publicado há aproximadamente 5 anos

$10-30 USD

Pago na entrega
When column B equals 1/2 and C10 equals EMT then multiply the value in D column by 10 and show result in C57. this is to be the same for all combinations of values (the combinations are shown in totals). I only want the values in column D to add add up according to the combination values in column B and C. the formulas I have in totals obviously don’t work. Btw this whole spreadsheet is made to upload to an app on Open As App, this doesn’t make a difference with the formula though, just context. Alot of the hidden columns are related to the app. Some of them just have data for lists also. I only have $15 also.
ID do Projeto: 19026546

Sobre o projeto

18 propostas
Projeto remoto
Ativo há 5 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Fixing the totals formulas as described in attached files. Basically changing it to SUMIFS formulas. Thanks, Milan
$15 USD em 0 dia
5,0 (457 avaliações)
6,9
6,9
18 freelancers estão ofertando em média $19 USD for esse trabalho
Avatar do Usuário
I am an expert and guru in Math and Excel/VBA/Macro. I  have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I create creative and sophisticated financial & statistic modules to investors and stockbrokers in a simplified and logical manner including explicit analysis by diagrams and graphs. I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.
$50 USD em 1 dia
4,9 (76 avaliações)
7,0
7,0
Avatar do Usuário
Hello, I am independent, experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
$25 USD em 1 dia
4,9 (118 avaliações)
6,3
6,3
Avatar do Usuário
I am a statistical analyst, with strong background of Pure Statistics including a strong grip on statistical software including SPSS, Excel, Minitab, STATA, SAS, Mathematica, Statistica and Eviews. Brilliant skills in Multivariate Analysis, Factor Analysis, Discriminant Analysis, Logistic and Multiple Logistic Regression, Panel; Cross Sectional & Time Series Analysis, Fixed & Random Effect Models, ANOVA, MANOVA, ANCOVA, Principal Component Analysis, Simple & Multiple Linear Regression, Non-Linear Models, Generalized Linear Models, Control Charts, Hypothesis Testing, Poisson Regression, Binary Data Analysis, Z-test, T-test, Chi-Square Test, F-test, Parametric Methods, Non Parametric Methods, Best Model Selection, Problems related to Inference, Estimation, Probability, Sampling, Calculus, Economics, Mathematics and vice versa. In-spite of data analysis task, I deliver high quality content on time at an affordable price. My work is done efficiently and effectively, & I meet clients' needs
$15 USD em 1 dia
4,9 (64 avaliações)
5,8
5,8
Avatar do Usuário
I can definitely create that formula. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform Financial Modeling, Financial Analysis, Financial Forecasting, Cash Flow Projections, Budgeting and various other customized and tailored analysis and computations. I will be happy to discuss in detail.
$25 USD em 1 dia
4,7 (47 avaliações)
5,4
5,4
Avatar do Usuário
Hello, I have take a look and I have the formula ready. It's easily done with a SUMIFS Please open a chat with me. Thanks, Sorin
$15 USD em 1 dia
5,0 (49 avaliações)
5,0
5,0
Avatar do Usuário
Over 10 yrs in excel and completed 60+ projects on this platform with over 4.9 rating. expert in applications of formulae, macros and VBA. Looking forward to speaking with you. Thank You Varun
$25 USD em 1 dia
4,9 (38 avaliações)
4,7
4,7
Avatar do Usuário
Hi there! That can easily be done using sumifs and also possible using else if condition. i.e if formula will find required combination in B11 it will not check further. But, if combination not found in B11, it will check B12 then B13 and so on. SUMIFS is best solution. I am interested to work on your project. Hope you will contact me. Thank you :) Regards - Bhakti
$15 USD em 1 dia
5,0 (12 avaliações)
4,7
4,7
Avatar do Usuário
Hello there, I am an Excel expert and I can solve this task for you. It's simple to me. Please contact and complete in 20 mins. Thanks
$15 USD em 1 dia
5,0 (45 avaliações)
4,5
4,5
Avatar do Usuário
hello! let me do it for you. Just award the project to me and share with me your spreadsheet and I will take care of the rest. Thanks
$15 USD em 1 dia
5,0 (22 avaliações)
4,3
4,3
Avatar do Usuário
Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5+ Yrs. of Experience in EXCEL & VBA. • Knowledge of FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Macro coding for USERFORM and other COMPLEX TASKS possible. • Password removal from Excel and VBA editor. • Work in TIGHT DEADLINE & HIGH ACCURACY. • Can start working IMMEDIATELY. Please ping me for more discussion.
$15 USD em 1 dia
4,9 (18 avaliações)
3,5
3,5
Avatar do Usuário
------------------------------------------- I am a lazy person so I started automating my work and became an expert in it. I have handled huge data and processed them with my automation skills. I have 9 years of experience in the Excel sheets and macro. Handled huge data in office. Completed many automation projects.
$15 USD em 1 dia
5,0 (3 avaliações)
1,5
1,5
Avatar do Usuário
Hello, I have fixed this formula for you. You may choose to use it or let me know if any other changes are needed. =SUM(IF(AND(B10="1/2")*AND(C10="EMT"),SUM(D10)*10,"0"),IF(AND(B11="1/2")*AND(C11="EMT"),SUM(D11)*10,"0")) I am based out of Hong Kong and going to bed now. Please expect a delay in reply. However, I am good to help if any further changes are needed.
$15 USD em 0 dia
5,0 (2 avaliações)
1,6
1,6
Avatar do Usuário
Hello I've looked at this using pure Excel formulas and can be done this way with conditional summing. One question is that the drop downs for each pipe diameter are stored as text fractions i.e. 3/4 But in the totals table are entered as inch text i.e. 3/4" Although this isn't a problem if the formulas are hard coded for the diameters matching it does make any future changes/expansion of the sheet far more time consuming - Is there any reason why the summary table pipe diameters can't be set the same as the drop down i.e. text 1/2 and NOT 1/2" ? Please message me if you'd like this done for you and the correct conditional formulas added etc. Regards Alan
$15 USD em 1 dia
5,0 (1 avaliação)
1,2
1,2
Avatar do Usuário
Hello Sir I am an advanced user of MS Excel, I can create this formula for you. I have made such type of formulas earlier as well. I can provide you a sample as well. I have completely understood your requirement and will comply to it. I can start working right now if you accept my bid. Looking forward to hear from you. Regards, Ali F.
$15 USD em 0 dia
4,6 (1 avaliação)
0,7
0,7
Avatar do Usuário
I am student of MSc. Mechatronics and Control engineering. My typing speed is very good. I will give you best service just give me a chance, I will prove my talent. I will provide you a quality work at very low price because I need review for starting work.
$15 USD em 1 dia
0,0 (0 avaliações)
1,7
1,7
Avatar do Usuário
Hi, I work on excel spreadhseets. Having good expertise in formulas and function. Please let me know if I can work on this project. Thanks Nagarjun
$15 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Topeka, United States
5,0
1
Método de pagamento verificado
Membro desde mar. 12, 2019

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.