Suoritettu

I need help with SUMIFS function

I have a large database with over 20 Columns, and I need Excel to choose and calculate the average of the values in last column, if the corresponding cells in two other columns meet certain criteria. I tried to do this with SUMIFS function and when I insert a second criterio the formula returns zero. SUMIF, works fine. In practical terms. I read in forums online that other people also have same problem with this function. In practice I need: If the name of the vessel in Vessel Column is Green or Dream (either will do) and the name in Port Column is Gdansk, I want excel to calculate the average of all values in last column where Vessel name is Green or Dream and port Name is Gdansk. So Either vessel name is Green and Port is Gdansk, or vessel name is Dream and Port name is Gdansk. I have created a compact file with only the necessary columns as example for ease, and also considering the original file contains sensitive information I cannot share. THank you

Rgs

Panos

Taidot: Excel, tietojenkäsittely, tiedonsyöttö, Matematiikka, Tilastotiede

Näytä lisää: i need help advertising my website, i need help designing a form, i need help designing a shirt, i need help designing clothes, i need help designing my van wrap, i need help find worker, i need help finding a manufacturer, i need help finding a shoes designer, i need help from an engineer, i need help from scientist, i need help getting my book edited not much money, i need help in designing a powerpoint presentation for a conference, i need help in getting leads to sell my service, i need help in writing a think piece, i need help in writing an executive summary, i need help in writing my project, i need help marketing my business, i need help marketing sales in frederick md, i need help on writing an essay, i need help setting up microsoft outlook 2013 in waltham

Tietoa työnantajasta:
( 2 arvostelua ) Vienna, Austria

Projektin tunnus: #20637303

Myönnetty käyttäjälle:

MimiFL

Hello, yes you need to apply SUMIF formula differently when you use it with multiple column criteria. If you are interested in working with me, please message me and i will try to help immediately. Thanks, Milan

€15 EUR 1 päivässä
(481 Arvostelua)
6.9

11 freelanceria on tarjonnut keskimäärin 20€ tähän työhön

coolmob0816

Dear sir. I have read your description carefully. I have a rich experience with math expert for 10 years. If you hire me, I will be best for you. I hope we can discuss in more details via chat. Regards.

€30 EUR 1 päivässä
(1 arvostelu)
3.1
Ahzakaria

I have an excellent experience in the following: - Excel Functions - KPIs - Dashboard - Excel VBA Developer - Data Analysis - Java Developer - Logistics & Supply Chain Excel Professional

€30 EUR 1 päivässä
(1 arvostelu)
2.4
krish258456

hello this is Krishna I'm a software engineer by profession i can finish your work easily contact me if u need any help

€19 EUR 2 päivässä
(0 arvostelua)
0.0
Vicedo

I could have done this without receiving payment but i need to pay the platform for its usage. Drop the file and i will do it and send back almost immediately

€23 EUR 1 päivässä
(0 arvostelua)
0.0
ZeeshanAmrack

Hello there, I'm interested in this opportunity and would love to do this task for your kind concern. Let's discuss this further without much delay and you will be provided with quality end results. Relevant Skills Lisää

€23 EUR 1 päivässä
(0 arvostelua)
0.0
vishalkhurana24

Give me one chance I’m sure next time you always choose me. Relevant Skills and Experience Excel

€22 EUR 1 päivässä
(0 arvostelua)
0.0
Hassanleo1987

Excel expert with 10+ years of experince in Data analysis for big projects.. Will deliever it quickly..

€22 EUR 1 päivässä
(0 arvostelua)
0.0
abdullah1531

Hello, I have already gone through the details from you. I think it is best suited for me. I am available from now on. I ensure you I will provide you a better quality work. So please call me an invitation. My rate wil Lisää

€8 EUR 1 päivässä
(0 arvostelua)
0.0
yogeeshsryd

Sir i am expert of excel i am using all sumif avrage if and all functions very quick making your work done within a day You test me sample project test

€8 EUR 1 päivässä
(0 arvostelua)
0.0
€23 EUR 3 päivässä
(0 arvostelua)
0.0