Forumlas including average

[DanielleParker7]

Hi,

I have a spreadsheet that I am using to track audits completed. At the bottom, it adds up and has to be in a certain range to turn red/amber/green over the 10 audits.

I was wondering how it is best to add a column in to work out if we only did 5 audits, but so that it still fits into the range of 10 audits. I assume the other 5 audits would need to take an average some how of the previous 5 to make it work out?

Hope this makes sense.

Thanks
Danielle

 

[etaf]

i would need a little more info and examples
Not sure i understand fully

do you have the Xl2BB add-in - see menu or my signature for details
Or add to a share like dropbox / onedrive /google sheets


maybe if you have conditions for RED /AMBER /GREEN
then proportion them based on the number of audits - not sure how the audits are marked

 

[DanielleParker7]

Thank you, I think we have now sorted this. If not I will upload a file.