Завершено

Fix my excel formulas

Hi there, I have two formulas that dont seem to be totalling my data correctly, I just need some help fine tuning them and making sure the totals match.

Really should take long, just my head is sore and want this report finished today :)

=SUMIF('DETAIL DATA'!C:N,C9,'DETAIL DATA'!K:K)

=SUMPRODUCT(VLOOKUP(C9,'DETAIL DATA'!$C$6:$AI$139,{19,20,21},0)).

I have attached the relevant file. In the REVENUE & GROWTH sheet, I have added notes in red in rows 1, 2 and 3.

Квалификация: Excel, Обработка данных, Ввод данных

Показать больше excel formulas website, genexus excel formulas, excel formulas document, write excel formulas, excel formulas escrow, excel formulas list, accounting excel formulas pro forma, post excel formulas website, websites excel formulas, excel formulas begin, using excel formulas, excel formulas assign rank based range numbers, outsourcing writing excel formulas, excel formulas rate calculator, excel formulas romania, excel formulas project, macro fix excel 2007, excel formulas temperature kelvin fahrenheit, mortgage excel formulas, excel formulas vlookup

О работодателе:
( 4 отзыв(-а, -ов) ) Kelvin Grove, Australia

ID проекта: #21804566

Поручен:

MimiFL

Hi, i've looked at the file and i believe i can help you. If you are interested in working with me, please message me so i can ask you few follow up questions regarding formulas you already have. I found what was the w Больше

$15 AUD за 1 день
(488 отзывов(-а))
7.0

16 фрилансеров(-а) в среднем готовы выполнить эту работу за $25

zebracaro

I can do it for you quickly and exactly by VBA, You don't need to use formula, just one click on the button .Please contact me for saving your time and your money Больше

$30 AUD за 1 день
(111 отзывов(-а))
7.0
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Больше

$50 AUD за 1 день
(117 отзывов(-а))
5.9
harsh2244

Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1* I can do Data RESEARCH from any platform for certain subjects Больше

$10 AUD за 1 день
(9 отзывов(-а))
4.1
Arahan00

Hi, I have checked the attached file. For the first mismatch, I got 306859 in H6 against 306860 in K2. I would like to work on the project. Let me know if you want to discuss further. Regards, Monir

$75 AUD за 1 день
(1 отзыв)
2.7
ravinderkumar248

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forw Больше

$10 AUD за 1 день
(3 отзывов(-а))
1.8
xxpc

Good evening, I can help you if you want with your excel sheet. Checking your excel I see that you have a circular reference. I can help you if you want today

$15 AUD за 1 день
(2 отзывов(-а))
1.0
frlncrsZviDAyqG

Hi Looked at the existing formulas, 1st one solved (306,860 in H6) - Just need to replicate across the 3 cols, second one shouldn't take too long Message me is you would like me to complete this now for you Rgds Больше

$25 AUD за 1 день
(1 отзыв)
1.1
greenguru2018

Hello How are you? I've read carefully your job description. I have more than seven years experience in Development. Your satisfaction with the project is my top priority! If you give me a chance to work with you, th Больше

$20 AUD за 7 дней(-я)
(1 отзыв)
0.5
applejoy0308

Good morning! I am an expert in excel formulas. I already attend also training for excel. Hoping to get the chance to work with you.

$20 AUD за 1 день
(0 отзывов(-а))
0.0
wowdeveloper

Hi, there I've read your all descriptions carefully and understood your all requests. I have done such projects many times before. So If you hire me, you can get wonderful result. I wish you communicate with me soon. B Больше

$30 AUD за 1 день
(0 отзывов(-а))
0.0
favtutor5

Hello, We have an expert team of Excel experts and Data Scientists with experience of 7+ years who can surely help you with your project. We pay attention on providing the best quality work and in building long terms r Больше

$20 AUD за 1 день
(0 отзывов(-а))
0.0
nikisingh20

hey i can done it easily and can solve your problem. i have 6 year of experience in this field . give me opportunity I'll assure you that my work will satisfied all your requirements. thank you waiting for your positiv Больше

$10 AUD за 1 день
(2 отзывов(-а))
0.0
vedddhuru

I have an MIS background which involves advance level of excel. Can rectify the formula issue without concern as this is a routine task.

$30 AUD за 2 дней(-я)
(0 отзывов(-а))
0.0
hasiya678

I have been working as a Data Entry and Data Extracting Expert for more than 5 years [login to view URL] my previous working years, I have finished many successful projects with 100% customer satisfaction. What makes me better than Больше

$10 AUD за 2 дней(-я)
(0 отзывов(-а))
0.0
syaffiqahyusri

Hello Mr/Mrs I am Syaffiqah Yusri, I will able to complete your task as well. So, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. Basically I am In Больше

$30 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0