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

Concluído Postado há 7 anos Pago na entrega
Concluído Pago na entrega

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

ID do Projeto: #13074497

Sobre o projeto

13 propostas Projeto remoto Ativo em há 7 anos

Concedido a:

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 Mais

$14 USD em 0 dias
(1164 Comentários)
8.4

13 freelancers estão ofertando em média $29 nesse trabalho

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 Mais

$30 USD em 1 dia
(503 Comentários)
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 f Mais

$55 USD em 1 dia
(93 Comentários)
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 yo Mais

$100 USD em 1 dia
(16 Comentários)
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 Mais

$25 USD em 1 dia
(3 Comentários)
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 on Mais

$15 USD in 0 dias
(5 Comentários)
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 em 1 dia
(1 Comentário)
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 yo Mais

$30 USD em 1 dia
(0 Comentários)
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 dias
(0 Comentários)
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 Mais

$13 USD in 0 dias
(0 Comentários)
0.0