I need a specific formula for an excel sheet im working on

$10-30 USD

Completed

Posted

about 7 years ago

$10-30 USD

Paid on delivery

We have a forumula to look add numbers if a certain word appears to the left of the number. The forumla is too long and I can only make use of it for a set number of columns. We need an advanced look up formula which performs the same function but much shorter in length. Here is the current formula =SUMIF(F12,"WOODLOT",G12)+SUMIF(H12,"WOODLOT",I12)+SUMIF(J12,"WOODLOT",K12)+SUMIF(L12,"WOODLOT",M12)+SUMIF(N12,"WOODLOT",O12)+SUMIF(P12,"WOODLOT",Q12)+SUMIF(R12,"WOODLOT",S12)+SUMIF(T12,"WOODLOT",U12)+SUMIF(V12,"WOODLOT",W12)+SUMIF(X12,"WOODLOT",Y12)+SUMIF(AD5,"WOODLOT",AE5)+SUMIF(AF5,"WOODLOT",AG5)+SUMIF(AH5,"WOODLOT",AI5)+SUMIF(AJ5,"WOODLOT",AK5)+SUMIF(AL5,"WOODLOT",AM5)+SUMIF(AN5,"WOODLOT",AO5)+SUMIF(AP5,"WOODLOT",AQ5)+SUMIF(AR5,"WOODLOT",AS5)+SUMIF(AT5,"WOODLOT",AU5)+SUMIF(AV5,"WOODLOT",AW5)+SUMIF(BB5,"WOODLOT",BC5)+SUMIF(BD5,"WOODLOT",BE5)+SUMIF(BF5,"WOODLOT",BG5)+SUMIF(BH5,"WOODLOT",BI5)+SUMIF(BJ5,"WOODLOT",BK5)+SUMIF(BL5,"WOODLOT",BM5)+SUMIF(BN5,"WOODLOT",BO5)+SUMIF(BP5,"WOODLOT",BQ5)+SUMIF(BR5,"WOODLOT",BS5)+SUMIF(BT5,"WOODLOT",BU5)+SUMIF(BZ5,"WOODLOT",CA5)+SUMIF(CB5,"WOODLOT",CC5)+SUMIF(CD5,"WOODLOT",CE5)+SUMIF(CF5,"WOODLOT",CG5)+SUMIF(CH5,"WOODLOT",CI5)+SUMIF(CJ5,"WOODLOT",CK5)+SUMIF(CL5,"WOODLOT",CM5)+SUMIF(CN5,"WOODLOT",CO5)+SUMIF(CP5,"WOODLOT",CQ5)+SUMIF(CR5,"WOODLOT",CS5)+SUMIF(CX5,"WOODLOT",CY5)+SUMIF(CZ5,"WOODLOT",DA5)+SUMIF(DB5,"WOODLOT",DC5)+SUMIF(DD5,"WOODLOT",DE5)+SUMIF(DF5,"WOODLOT",DG5)+SUMIF(DH5,"WOODLOT",DI5)+SUMIF(DJ5,"WOODLOT",DK5)+SUMIF(DL5,"WOODLOT",DM5)+SUMIF(DN5,"WOODLOT",DO5)+SUMIF(DP5,"WOODLOT",DQ5)+SUMIF(DV5,"WOODLOT",DW5)+SUMIF(DX5,"WOODLOT",DY5)+SUMIF(DZ5,"WOODLOT",EA5)+SUMIF(EB5,"WOODLOT",EC5)+SUMIF(ED5,"WOODLOT",EE5)+SUMIF(EF5,"WOODLOT",EG5)+SUMIF(EH5,"WOODLOT",EI5)+SUMIF(EJ5,"WOODLOT",EK5)+SUMIF(EL5,"WOODLOT",EM5)+SUMIF(EN5,"WOODLOT",EO5)+SUMIF(ET5,"WOODLOT",EU5)+SUMIF(EV5,"WOODLOT",EW5)+SUMIF(EX5,"WOODLOT",EY5)+SUMIF(EZ5,"WOODLOT",FA5)+SUMIF(FB5,"WOODLOT",FC5)+SUMIF(FD5,"WOODLOT",FE5)+SUMIF(FF5,"WOODLOT",FG5)+SUMIF(FH5,"WOODLOT",FI5)+SUMIF(FJ5,"WOODLOT",FK5)+SUMIF(FL5,"WOODLOT",FM5)+SUMIF(FR5,"WOODLOT",FS5)+SUMIF(FT5,"WOODLOT",FU5)+SUMIF(FV5,"WOODLOT",FW5)+SUMIF(FX5,"WOODLOT",FY5)+SUMIF(FZ5,"WOODLOT",GA5)+SUMIF(GB5,"WOODLOT",GC5)+SUMIF(GD5,"WOODLOT",GE5)+SUMIF(GF5,"WOODLOT",GG5)+SUMIF(GH5,"WOODLOT",GI5)+SUMIF(GJ5,"WOODLOT",GK5)+SUMIF(GP5,"WOODLOT",GQ5)+SUMIF(GR5,"WOODLOT",GS5)+SUMIF(GT5,"WOODLOT",GU5)+SUMIF(GV5,"WOODLOT",GW5)+SUMIF(GX5,"WOODLOT",GY5)+SUMIF(GZ5,"WOODLOT",HA5)+SUMIF(HB5,"WOODLOT",HC5)+SUMIF(HD5,"WOODLOT",HE5)+SUMIF(HF5,"WOODLOT",HG5)+SUMIF(HH5,"WOODLOT",HI5)+SUMIF(HN5,"WOODLOT",HO5)+SUMIF(HP5,"WOODLOT",HQ5)+SUMIF(HR5,"WOODLOT",HS5)+SUMIF(HT5,"WOODLOT",HU5)+SUMIF(HV5,"WOODLOT",HW5)+SUMIF(HX5,"WOODLOT",HY5)+SUMIF(HZ5,"WOODLOT",IA5)+SUMIF(IB5,"WOODLOT",IC5)+SUMIF(ID5,"WOODLOT",IE5)+SUMIF(IF5,"WOODLOT",IG5)+SUMIF(IL5,"WOODLOT",IM5)+SUMIF(IN5,"WOODLOT",IO5)+SUMIF(IP5,"WOODLOT",IQ5)+SUMIF(IR5,"WOODLOT",IS5)+SUMIF(IT5,"WOODLOT",IU5)+SUMIF(IV5,"WOODLOT",IW5)+SUMIF(IX5,"WOODLOT",IY5)+SUMIF(IZ5,"WOODLOT",JA5)+SUMIF(JB5,"WOODLOT",JC5)+SUMIF(JD5,"WOODLOT",JE5)+SUMIF(JJ5,"WOODLOT",JK5)+SUMIF(JL5,"WOODLOT",JM5)+SUMIF(JN5,"WOODLOT",JO5)+SUMIF(JP5,"WOODLOT",JQ5)+SUMIF(JR5,"WOODLOT",JS5)+SUMIF(JT5,"WOODLOT",JU5)+SUMIF(JV5,"WOODLOT",JW5)+SUMIF(JX5,"WOODLOT",JY5)+SUMIF(JZ5,"WOODLOT",KA5)

Excel

Project ID: 13074497

About the project

13 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@cgullapalli

Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat. and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra

$14 USD in 0 day

5.0

(1164 reviews)

8.4

13 freelancers are bidding on average $29 USD for this job

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

$30 USD in 1 day

4.9

(503 reviews)

8.4

@dgled

Hi, I can convert the formula by VBA or pivot table. I create all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards I am a specialist in financial reports, budget, costing reports, inventories, bill of materials construction models together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports, dynamic dashboard, and graphs. Throughout my career, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services. And have bullied all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards. Areas of expertise: • Implementation of information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP B1, ERP, Venture Capital system, CRM, etc.). • Developing of consolidated financial statements, financial plans (fitted to due diligence), feasibility studies, and measurement reporting tools for global companies. • Business valuation and ratios (NPV, IRR, DCF, ROA, ROE, MCDA, CPI, SPI, EVM, KPI, Monte Carlo technique). • Extensive experience in accounting, consolidating, forecasting, budgeting, and costing.

$55 USD in 1 day

4.9

(93 reviews)

7.5

@Ayo25

I am a statistician with advanced knowledge of microsoft excel. I have experience with data entry and statistical calculations.I work fast and deliver my projects on time. Looking forward to working with you. Thank you.

$100 USD in 1 day

5.0

(16 reviews)

6.2

@sharpzulfiqar

Dear Client, I am an experienced IT professional and experienced in office packages including excel, word and powerpoint. I have served the clients throughout the globe and believe in long term relationships, so I work upto client satisfaction and tries to earn clients instead of money. I have reviewed your job post and wondering to discuss the details of the job, so that i can give you a realistic timeline and bid amount. I assure you of your satisfaction and accuracy in the work, if i will take the job. So please let me know, when we can discuss? I am ready to start as soon as awarded. Will be waiting for your response to start. Warm Regards Zulfiqar Ali

$25 USD in 1 day

5.0

(3 reviews)

5.0

@etiamm

Dear employer, I have been in this industry for more than 10 years and such jobs are my daily practice. I am new on this site, just did three projects with best ratings. I can assure you that if you work with me once, you will always work with me for these kinds of projects. I have advanced excel knowledge, can use: 1. Statistical functions 2. Logical functions 3. Date & time functions 4. Lookup and reference functions 5. Text functions 6. Information functions 7. Pivot, conditional formatting 8. Chart drawing etc. Also, I am detail oriented person with good organizational and analytic skills. Your project in not complicate, can be done very fast. I am available. Best regards, Slobodan

$15 USD in 0 day

4.9

(5 reviews)

2.8

@uzmamani

i can make it shortened if u share with me the original data file rather than just formula. it can be short because same criteria is being repeating.

$20 USD in 1 day

5.0

(1 review)

0.8

@DeveloperFriendz

Hello, I wish you'd give me this chance. I have consistently delivered projects on time and under budget.I believe my skills would be ideal for your project and I look forward for the chance to work with you! Thank you

$30 USD in 1 day

0.0

(0 reviews)

0.0

@harshadabhan

I have good corporate experience. Im from Thane , mumbai. I worked for 4 years corporate.. Now doing work from home. I have 3g internet speed. I will dedicate only 1 project at one time.

$30 USD in 25 days

0.0

(0 reviews)

0.0

@Pietrofarias

Let's work on this formula? We could create a function through VBA to make it simpler. But still we could use other ways to get lighter. I believe that this formula, if it is in many cells, should weigh the file. Can we talk abou it?

$13 USD in 0 day