Sorry about this Roger,
I tried this
but...=IF(AI13&AW13&BI13&BW13&CJ13="N","",IF(AI13& AW13&BI13&BW13&CJ13="R","",SUM(AI13/100)+(AW13/100)+(BI13/100)+(BW13/100)+(CJ13/100)))
The cell I'm putting this formula into is L13. However, I still get that
(#Value) if one of the reference cells are blank also the last part of this
formula doesn't give me a percentage out of 100 if you get what I mean...what
I'm trying to achieve is, for example, getting 5 different scores say
80,79,31,56,73 to only give me a percentage out of 100....does that make
sense??

Cheers
David