-
excell has relative and absolute references '$' locked the coding $A$1 lockes to cell A1 so code $A$1*B1 spilled down four cells would then be $A$1*B4
=sum( can also be needed though that viaries with versions of XLS. =Sum($A$1*B1) and so on
Have fun and post your sheet if it fails for us to play with for you
-
DOH!!
Tombie I worked it out from your examples - I knew i was overthinking it. Thanks to other posters well. BTW Classic88 =C13 does work too but only if i put it in right cell [emoji849][emoji5]
