# #Value returned in cell, when Formula window return correct

#### ariel998

##### New Member
I'm having a small issue with a formula returning a #value in the cell, but if viewed in the Formula step through window the correct result is returned.

=(SUM(\$N\$10:AZ\$10)*IF(\$N\$3:\$AY\$3<=Now,1,0))

Result in Cell = #Value

This formula works in another worksheet, however when the field is not selected it is displayed with {} (as below).

{=(SUM(\$N\$10:AZ\$10)*IF(\$N\$3:\$AY\$3<=Now,1,0))}

Result in Cell - as desired, the total SUM of all cells before and including the current month.

Any light that can be shed on this problem would be a HUGE help.

The problem formula is used in the sheet pictured below: "Now" - is Sept-06

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=20><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - New Post.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: 11.0 : OS = Windows XP </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=20><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb605117><INPUT onclick='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);' type=button value="Copy Formula" name=btCb942116></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=20><TABLE border=0><TBODY><TR><FORM name=formFb202339><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name=sltNb447362><OPTION value==CurrencyThisProject selected>A2<OPTION value==DIRECTS!B1>C2<OPTION value==DIRECTS!C1>D2<OPTION value==DIRECTS!D1>E2<OPTION value==DIRECTS!E1>F2<OPTION value==DIRECTS!F1>G2<OPTION value==DIRECTS!G1>H2<OPTION value==DIRECTS!H1>I2<OPTION value==DIRECTS!I1>J2<OPTION value==DIRECTS!J1>K2<OPTION value==DIRECTS!K1>L2<OPTION value==CurrencyThisProject>A3<OPTION value==DIRECTS!B1>C3<OPTION value==DIRECTS!C1>D3<OPTION value==DIRECTS!D1>E3<OPTION value==DIRECTS!E1>F3<OPTION value==DIRECTS!F1>G3<OPTION value==DIRECTS!G1>H3<OPTION value==DIRECTS!H1>I3<OPTION value==DIRECTS!I1>J3<OPTION value==DIRECTS!J1>K3<OPTION value==DIRECTS!K1>L3<OPTION value==DIRECTS!M1>M3<OPTION value==DIRECTS!N1>N3<OPTION value==DIRECTS!O1>O3<OPTION value==DIRECTS!P1>P3<OPTION value==DIRECTS!Q1>Q3<OPTION value==DIRECTS!R1>R3<OPTION value==DIRECTS!S1>S3<OPTION value==C5*C8>C4<OPTION value==D5*D8>D4<OPTION value==E5*E8>E4<OPTION value==F5*F8>F4<OPTION value==G5*G8>G4<OPTION value==H5*H8>H4<OPTION value==I5*I8>I4<OPTION value==J5*J8>J4<OPTION value==K5*K8>K4<OPTION value==L5*L8>L4<OPTION value==M5*M8>M4<OPTION value==N5*N8>N4<OPTION value==O5*O8>O4<OPTION value==P5*P8>P4<OPTION value==Q5*Q8>Q4<OPTION value==R5*R8>R4<OPTION value==S5*S8>S4<OPTION value==SUM(C23,C25,C27,C29,C31,C33,C35,C37,C39,C41,C43,C45,C47,C49,C51,C53,C55,C57,C59,C61,C63,C65,C67,C69,C71)>C5<OPTION value==SUM(D23,D25,D27,D29,D31,D33,D35,D37,D39,D41,D43,D45,D47,D49,D51,D53,D55,D57,D59,D61,D63,D65,D67,D69,D71)>D5<OPTION value==SUM(E23,E25,E27,E29,E31,E33,E35,E37,E39,E41,E43,E45,E47,E49,E51,E53,E55,E57,E59,E61,E63,E65,E67,E69,E71)>E5<OPTION value==SUM(F23,F25,F27,F29,F31,F33,F35,F37,F39,F41,F43,F45,F47,F49,F51,F53,F55,F57,F59,F61,F63,F65,F67,F69,F71)>F5<OPTION value==SUM(G23,G25,G27,G29,G31,G33,G35,G37,G39,G41,G43,G45,G47,G49,G51,G53,G55,G57,G59,G61,G63,G65,G67,G69,G71)>G5<OPTION value==SUM(H23,H25,H27,H29,H31,H33,H35,H37,H39,H41,H43,H45,H47,H49,H51,H53,H55,H57,H59,H61,H63,H65,H67,H69,H71)>H5<OPTION value==SUM(I23,I25,I27,I29,I31,I33,I35,I37,I39,I41,I43,I45,I47,I49,I51,I53,I55,I57,I59,I61,I63,I65,I67,I69,I71)>I5<OPTION value==SUM(J23,J25,J27,J29,J31,J33,J35,J37,J39,J41,J43,J45,J47,J49,J51,J53,J55,J57,J59,J61,J63,J65,J67,J69,J71)>J5<OPTION value==SUM(K23,K25,K27,K29,K31,K33,K35,K37,K39,K41,K43,K45,K47,K49,K51,K53,K55,K57,K59,K61,K63,K65,K67,K69,K71)>K5<OPTION value==SUM(L23,L25,L27,L29,L31,L33,L35,L37,L39,L41,L43,L45,L47,L49,L51,L53,L55,L57,L59,L61,L63,L65,L67,L69,L71)>L5<OPTION value==SUM(M23,M25,M27,M29,M31,M33,M35,M37,M39,M41,M43,M45,M47,M49,M51,M53,M55,M57,M59,M61,M63,M65,M67,M69,M71)>M5<OPTION value==SUM(N23,N25,N27,N29,N31,N33,N35,N37,N39,N41,N43,N45,N47,N49,N51,N53,N55,N57,N59,N61,N63,N65,N67,N69,N71)>N5<OPTION value==SUM(O23,O25,O27,O29,O31,O33,O35,O37,O39,O41,O43,O45,O47,O49,O51,O53,O55,O57,O59,O61,O63,O65,O67,O69,O71)>O5<OPTION value==SUM(P23,P25,P27,P29,P31,P33,P35,P37,P39,P41,P43,P45,P47,P49,P51,P53,P55,P57,P59,P61,P63,P65,P67,P69,P71)>P5<OPTION value==SUM(Q23,Q25,Q27,Q29,Q31,Q33,Q35,Q37,Q39,Q41,Q43,Q45,Q47,Q49,Q51,Q53,Q55,Q57,Q59,Q61,Q63,Q65,Q67,Q69,Q71)>Q5<OPTION value==SUM(R23,R25,R27,R29,R31,R33,R35,R37,R39,R41,R43,R45,R47,R49,R51,R53,R55,R57,R59,R61,R63,R65,R67,R69,R71)>R5<OPTION value==SUM(S23,S25,S27,S29,S31,S33,S35,S37,S39,S41,S43,S45,S47,S49,S51,S53,S55,S57,S59,S61,S63,S65,S67,S69,S71)>S5<OPTION value==SUM(C22,C24,C26,C28,C30,C32,C34,C36,C38,C40,C42,C44,C46,C48,C50,C52,C54,C56,C58,C60,C62,C64,C66,C68,C70)>C6<OPTION value==SUM(D22,D24,D26,D28,D30,D32,D34,D36,D38,D40,D42,D44,D46,D48,D50,D52,D54,D56,D58,D60,D62,D64,D66,D68,D70)>D6<OPTION value==SUM(E22,E24,E26,E28,E30,E32,E34,E36,E38,E40,E42,E44,E46,E48,E50,E52,E54,E56,E58,E60,E62,E64,E66,E68,E70)>E6<OPTION value==SUM(F22,F24,F26,F28,F30,F32,F34,F36,F38,F40,F42,F44,F46,F48,F50,F52,F54,F56,F58,F60,F62,F64,F66,F68,F70)>F6<OPTION value==SUM(G22,G24,G26,G28,G30,G32,G34,G36,G38,G40,G42,G44,G46,G48,G50,G52,G54,G56,G58,G60,G62,G64,G66,G68,G70)>G6<OPTION value==SUM(H22,H24,H26,H28,H30,H32,H34,H36,H38,H40,H42,H44,H46,H48,H50,H52,H54,H56,H58,H60,H62,H64,H66,H68,H70)>H6<OPTION value==SUM(I22,I24,I26,I28,I30,I32,I34,I36,I38,I40,I42,I44,I46,I48,I50,I52,I54,I56,I58,I60,I62,I64,I66,I68,I70)>I6<OPTION value==SUM(J22,J24,J26,J28,J30,J32,J34,J36,J38,J40,J42,J44,J46,J48,J50,J52,J54,J56,J58,J60,J62,J64,J66,J68,J70)>J6<OPTION value==SUM(K22,K24,K26,K28,K30,K32,K34,K36,K38,K40,K42,K44,K46,K48,K50,K52,K54,K56,K58,K60,K62,K64,K66,K68,K70)>K6<OPTION value==SUM(L22,L24,L26,L28,L30,L32,L34,L36,L38,L40,L42,L44,L46,L48,L50,L52,L54,L56,L58,L60,L62,L64,L66,L68,L70)>L6<OPTION value==SUM(M22,M24,M26,M28,M30,M32,M34,M36,M38,M40,M42,M44,M46,M48,M50,M52,M54,M56,M58,M60,M62,M64,M66,M68,M70)>M6<OPTION value==SUM(N24,N26,N28,N30,N32,N34,N36,N38,N40,N42,N44,N46,N48,N50,N52,N54,N56,N58,N60,N62,N64,N66,N68,N70,N72)>N6<OPTION value==SUM(O24,O26,O28,O30,O32,O34,O36,O38,O40,O42,O44,O46,O48,O50,O52,O54,O56,O58,O60,O62,O64,O66,O68,O70,O72)>O6<OPTION value==SUM(P24,P26,P28,P30,P32,P34,P36,P38,P40,P42,P44,P46,P48,P50,P52,P54,P56,P58,P60,P62,P64,P66,P68,P70,P72)>P6<OPTION value==SUM(Q24,Q26,Q28,Q30,Q32,Q34,Q36,Q38,Q40,Q42,Q44,Q46,Q48,Q50,Q52,Q54,Q56,Q58,Q60,Q62,Q64,Q66,Q68,Q70,Q72)>Q6<OPTION value==SUM(R24,R26,R28,R30,R32,R34,R36,R38,R40,R42,R44,R46,R48,R50,R52,R54,R56,R58,R60,R62,R64,R66,R68,R70,R72)>R6<OPTION value==SUM(S24,S26,S28,S30,S32,S34,S36,S38,S40,S42,S44,S46,S48,S50,S52,S54,S56,S58,S60,S62,S64,S66,S68,S70,S72)>S6<OPTION value="=(SUM(\$N\$10:AZ\$10)*IF(\$N\$3:\$AY\$3<=Now,1,0))">E10</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==CurrencyThisProject name=txbFb150492></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[30].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[31].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[32].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[33].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[34].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[35].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[36].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[37].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[38].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right">\$0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right">\$0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right">\$0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right">\$0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right">\$0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right">\$0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right">\$0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>5</CENTER></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Total Labour (Hours)</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[46].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[47].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[48].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[49].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[50].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[51].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[52].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[53].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[54].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[55].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>6</CENTER></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Total Labour (Hours) Forecast </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[63].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[64].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[65].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[66].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[67].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[68].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[69].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[70].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[71].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right"><A onclick="document.formFb202339.sltNb447362.options[72].selected=true; document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #00ff00; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>7</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>8</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">LABOUR RATE /hr (Project Currencyt)</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right">1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right">1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right">1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right">1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial Narrow; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: right">1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top;

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

##### MrExcel MVP
you need to enter the forumla with control + shift + enter, not just enter.

review the excel help file for 'About array formulas and array constants'

#### Brian from Maui

##### MrExcel MVP
A non array would be something like,

=SUM(INDEX(N10:AZ10,0,MATCH(A1,N3:AZ3,0)))

Where A1 contains the date

#### ariel998

##### New Member
Thank you verny much for the answer and for pointing me in the right direction. I have to admit I was lost.

Much appreciated

Replies
0
Views
130
Replies
4
Views
572
Replies
5
Views
524
Replies
12
Views
426
Replies
13
Views
1K

1,130,167
Messages
5,640,539
Members
417,151
Latest member
ChickenTenderer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back