Hi all,
My apologies if this has been posted elsewhere - I'm a relative novice and unsure of the terminology which could describe my request.
I have a data sheet stretching from A1:AK225. In column AL, say, I would like to include a cell with a formula that will do the following:
= (B5/($B$3*$B$4)) + (C5/($C$3*$C$4)) + (D5/($D$3*$D$4)).... and so on up to column AK. Once I've done this once, I'd fill in down to row 225.
Is there a formula I can use which will allow me to do all of this without entering manually (which I have already done in my desperation!)
Many thanks,
SW
Bookmarks