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
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
11 freelanceria on tarjonnut keskimäärin 20€ tähän työhön
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.
I have an excellent experience in the following: - Excel Functions - KPIs - Dashboard - Excel VBA Developer - Data Analysis - Java Developer - Logistics & Supply Chain Excel Professional
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
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