Originally Posted by
dancing-shadow
Thanks for that...
Regarding the layout, trust me, if I had the power to amend it to be the full figure in just one cell, I would. Management, as always, know best and insist is stays as it is, hence why I'm trying to make it work in the ****-eyed fashion it is.
I have tried your above formulas, and before I even try to get my head around how they work/what they do (I'm familiar with 'INT', but 'SUMPRODUCT' and the -- bit baffles me...) I've noticed the last one for H40 gives an answer of 100 (with the current figures on the example). I'm more than happy to play around with it and make your 'starters' work for the rest, but are you able to amend/fix/etc that last one please?
Bookmarks