Đã hoàn thành

Create a Formula on Excel According to the Criteria Provided

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.

Kĩ năng: Lập trình C#, Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic

Xem nhiều hơn: how to create a formula in excel 2016, how to use excel formulas, excel formulas pdf, advanced excel formulas, sumif excel, if function excel, excel formulas cheat sheet, excel formulas, interest payment formula excel, create labels excel, advertising formula excel, formula excel, create permutation excel list, create pricelist excel, lowest bid formula excel, create xml excel vba, create automatic excel graph, create calculator excel, create configurator excel, create simple excel php

Về Bên Thuê:
( 1 Nhận xét ) Topeka, United States

ID dự án: #19026546

Được trao cho:

MimiFL

Fixing the totals formulas as described in attached files. Basically changing it to SUMIFS formulas. Thanks, Milan

$15 USD trong 0 ngày
(457 Đánh Giá)
6.9

18 freelancer đang chào giá trung bình $19 cho công việc này

dgled

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 ( Thêm

$50 USD trong 1 ngày
(76 Nhận xét)
7.0
rinabuoy13

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 trong 1 ngày
(118 Nhận xét)
6.3
ZeeshanShah22

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 Thêm

$15 USD trong 1 ngày
(64 Nhận xét)
5.8
daniyal3214

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 Thêm

$25 USD trong 1 ngày
(47 Nhận xét)
5.4
sorinacho88

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 trong 1 ngày
(49 Nhận xét)
5.0
BAVarun

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 trong 1 ngày
(38 Nhận xét)
4.7
Devotion20

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 Thêm

$15 USD trong 1 ngày
(12 Nhận xét)
4.7
nvchien94

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 trong 1 ngày
(45 Nhận xét)
4.5
sevillajk01

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 trong 1 ngày
(22 Nhận xét)
4.3
srijanagrawal21

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 Thêm

$15 USD trong 1 ngày
(18 Nhận xét)
3.5
shahbaz143

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 Thêm

$15 USD trong 0 ngày
(2 Nhận xét)
1.6
qinchetan

------------------------------------------- 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 exp Thêm

$15 USD trong 1 ngày
(3 Nhận xét)
1.5
frlncrsZviDAyqG

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 Thêm

$15 USD trong 1 ngày
(1 Nhận xét)
1.2
silverrock

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 an Thêm

$15 USD trong 0 ngày
(1 Nhận xét)
0.7
techplusintl

Hi there, Greetings from TechPlus! I've reviewed requirements & ready to Create a Formula on Excel According to the Criteria Provided. 5+ Years Expertise in : CMS (Wordpress, Magento, Shopify, OpenCart, Jooml Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
nagarjunjntu

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 trong 1 ngày
(0 Nhận xét)
0.0
ManormaShehzadi

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 Thêm

$15 USD trong 1 ngày
(0 Nhận xét)
1.7