Hello
Please can anyone tell me how to shorten the following formula as it is coming up with a 'text too long' error message when I try to enter it into a cell. As you can see it is a repeated 'IF' arguement, in which the first and third cell references increase by one each time. The second reference in the arguement remains constant (H83). This makes me think there must be a way to ask it to repeat the arguement, just within a range...
=IF(H7=H83,J7,0)+IF(H8=H83,J8,0)+IF(H9=H83,J9,0)+IF(H10=H83,J10,0)+IF(H11=H83,J11,0)+IF(H12=H83,J12,0)+IF(H13=H83,J13,0)+IF(H14=H83,J14,0)+IF(H15=H83,J15,0)+IF(H16=H83,J16,0)+IF(H17=H83,J17,0)+IF(H18=H83,J18,0)+IF(H19=H83,J19,0)+IF(H20=H83,J20,0)+IF(H21=H83,J21,0)+IF(H22=H83,J22,0)+IF(H23=H83,J23,0)+IF(H24=H83,J24,0)+IF(H25=H83,J25,0)+IF(H26=H83,J26,0)+IF(H27=H83,J27,0)+IF(H28+H83,J28,0)+IF(H29=H83,J29,0)+IF(H30=H83,J30,0)+IF(H31=H83,J31,0)+IF(H32=H83,J32,0)+IF(H33=H83,J33,0)+IF(H34=H83,J34,0)+IF(H35=H83,J35,0)+IF(H36=H83,J36,0)+IF(H37=H83,J37,0)+IF(H38=H83,J38,0)+IF(H39=H83,J39,0)+IF(H40=H83,J40,0)+IF(H41=H83,J41,0)+IF(H42=H83,J42,0)+IF(H43=H83,J43,0)+IF(H44=H83,J44,0)+IF(H45=H83,J45,0)+IF(H46=H83,J46,0)+IF(H47=H83,J47,0)+IF(H48=H83,J48,0)+IF(H49=H83,J49,0)+IF(H50=H83,J50,0)+IF(H51=H83,J51,0)+IF(H52=H83,J52,0)+IF(H53=H83,J53,0)+IF(H54=H83,J54,0)+IF(H55=H83,J55,0)+IF(H56=H83,J56,0)+IF(H57=H83,J57,0)+IF(H58=H83,J58,0)+IF(H59=H83,J59,0)+IF(H60=H83,J60,0)+IF(H61=H83,J61,0)+IF(H62=H83,J62,0)+IF(H63=H83,J63,0)+IF(H64=H83,J64,0)+IF(H65=H83,J65,0)+IF(H66=H83,J66,0)+IF(H67=H83,J67,0)+IF(H68=H83,J68,0)+IF(H69=H83,J69,0)+IF(H70=H83,J70,0)+IF(H71=H83,J71,0)+IF(H72=H83,J72,0)+IF(H73=H83,J73,0)+IF(H74=H83,J74,0)+IF(H75=H83,J75,0)+IF(H76=H83,J76,0)+IF(H77=H83,J77,0)+IF(H78=H83,J78,0)+IF(H79=H83,J79,0)
Thanks in advance
CFOSTER
Please can anyone tell me how to shorten the following formula as it is coming up with a 'text too long' error message when I try to enter it into a cell. As you can see it is a repeated 'IF' arguement, in which the first and third cell references increase by one each time. The second reference in the arguement remains constant (H83). This makes me think there must be a way to ask it to repeat the arguement, just within a range...
=IF(H7=H83,J7,0)+IF(H8=H83,J8,0)+IF(H9=H83,J9,0)+IF(H10=H83,J10,0)+IF(H11=H83,J11,0)+IF(H12=H83,J12,0)+IF(H13=H83,J13,0)+IF(H14=H83,J14,0)+IF(H15=H83,J15,0)+IF(H16=H83,J16,0)+IF(H17=H83,J17,0)+IF(H18=H83,J18,0)+IF(H19=H83,J19,0)+IF(H20=H83,J20,0)+IF(H21=H83,J21,0)+IF(H22=H83,J22,0)+IF(H23=H83,J23,0)+IF(H24=H83,J24,0)+IF(H25=H83,J25,0)+IF(H26=H83,J26,0)+IF(H27=H83,J27,0)+IF(H28+H83,J28,0)+IF(H29=H83,J29,0)+IF(H30=H83,J30,0)+IF(H31=H83,J31,0)+IF(H32=H83,J32,0)+IF(H33=H83,J33,0)+IF(H34=H83,J34,0)+IF(H35=H83,J35,0)+IF(H36=H83,J36,0)+IF(H37=H83,J37,0)+IF(H38=H83,J38,0)+IF(H39=H83,J39,0)+IF(H40=H83,J40,0)+IF(H41=H83,J41,0)+IF(H42=H83,J42,0)+IF(H43=H83,J43,0)+IF(H44=H83,J44,0)+IF(H45=H83,J45,0)+IF(H46=H83,J46,0)+IF(H47=H83,J47,0)+IF(H48=H83,J48,0)+IF(H49=H83,J49,0)+IF(H50=H83,J50,0)+IF(H51=H83,J51,0)+IF(H52=H83,J52,0)+IF(H53=H83,J53,0)+IF(H54=H83,J54,0)+IF(H55=H83,J55,0)+IF(H56=H83,J56,0)+IF(H57=H83,J57,0)+IF(H58=H83,J58,0)+IF(H59=H83,J59,0)+IF(H60=H83,J60,0)+IF(H61=H83,J61,0)+IF(H62=H83,J62,0)+IF(H63=H83,J63,0)+IF(H64=H83,J64,0)+IF(H65=H83,J65,0)+IF(H66=H83,J66,0)+IF(H67=H83,J67,0)+IF(H68=H83,J68,0)+IF(H69=H83,J69,0)+IF(H70=H83,J70,0)+IF(H71=H83,J71,0)+IF(H72=H83,J72,0)+IF(H73=H83,J73,0)+IF(H74=H83,J74,0)+IF(H75=H83,J75,0)+IF(H76=H83,J76,0)+IF(H77=H83,J77,0)+IF(H78=H83,J78,0)+IF(H79=H83,J79,0)
Thanks in advance
CFOSTER