En cours

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

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)

Compétences : Excel

Voir plus : im good with excel i need an online job, im 20 and need a manager i can sing, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, urgent need formula solve equations unknowns excel need, payroll working sheet excel, formula sheet excel, seller net sheet excel, excel extra repayment formula, code update sheet excel, format salary sheet excel, buyers net sheet excel, assumption sheet excel, shift roster sheet excel, real estate net sheet excel

Concernant l'employeur :
( 43 commentaires ) Steinbach, Canada

N° du projet : #13074497

Décerné à :

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 f Plus

14 $ USD en 0 jours
(348 Commentaires)
7.1

14 freelancers are bidding on average $28 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 ex Plus

30 $ USD en 1 jour
(100 Commentaires)
6.1
andriphone0

Hello, I saw your job post that is related to my skills. Please refer to your PM. So I can create sample work right away before awarding the project. I have 3 year working experience on-Web Research, lead generation, Plus

25 $ USD en 1 jour
(42 Commentaires)
5.1
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 f Plus

55 $ USD en 1 jour
(11 Commentaires)
4.5
10 $ USD en 1 jour
(12 Commentaires)
3.9
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 Plus

25 $ USD en 1 jour
(1 Commentaire)
3.6
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 yo Plus

100 $ USD en 1 jour
(3 Commentaires)
3.3
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 on Plus

15 $ USD en 0 jours
(3 Commentaires)
2.4
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 yo Plus

30 $ USD en 1 jour
(0 Commentaires)
0.0
25 $ USD en 1 jour
(0 Commentaires)
0.0
Ashisjena2015

I can complete it immediately but I need five rating on completion of [url removed, login to view] discuss over chat [url removed, login to view] you share your file, I can work and send you. I am very good at excel. You can test me before awarding project.

10 $ USD en 0 jours
(1 Commentaire)
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 en 25 jours
(0 Commentaires)
0.0
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 en 1 jour
(0 Commentaires)
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 Plus

13 $ USD en 0 jours
(0 Commentaires)
0.0
alteregoanne

I'm online now

10 $ USD en 0 jours
(0 Commentaires)
0.0