I have created a formula in Excel as below: =SUM(IF(Data1!B1:B155=B9, IF(Data1!C1:C155=AD10,IF(Data1!I1:I155 = 2, Data1!L1:L153,0),0),0))
But it is not displaying the result in the cell. If i am in the formula and do a F9 (Calculate) it will bring the correct result through but will make the formula disapear. How can i get it to show the formula in the text line at the top but show the result in the cell like normal?
Cheers
Tom
