Käynnissä

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)

Taidot: Excel

Näytä lisää: 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

About the Employer:
( 43 reviews ) Steinbach, Canada

Projektin tunnus: #13074497

Myönnetty käyttäjälle:

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 Lisää

14 $ USD 0 päivässä
(348 arvostelua)
7.1

14 freelanceria on tarjonnut keskimäärin 28 $ tähän työhön

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 Lisää

30 $ USD 1 päivässä
(100 arvostelua)
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, Lisää

25 $ USD 1 päivässä
(42 arvostelua)
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 Lisää

55 $ USD 1 päivässä
(11 arvostelua)
4.5
10 $ USD 1 päivässä
(12 arvostelua)
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 Lisää

25 $ USD 1 päivässä
(1 arvostelu)
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 Lisää

100 $ USD 1 päivässä
(3 arvostelua)
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 Lisää

15 $ USD 0 päivässä
(3 arvostelua)
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 Lisää

30 $ USD 1 päivässä
(0 arvostelua)
0.0
25 $ USD 1 päivässä
(0 arvostelua)
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 0 päivässä
(1 arvostelu)
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 25 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
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 Lisää

13 $ USD 0 päivässä
(0 arvostelua)
0.0
alteregoanne

I'm online now

10 $ USD 0 päivässä
(0 arvostelua)
0.0