( by Tom Krieglstein )
Have a look at the following screenshot of my spreadsheet:
the above formula will give you the average value from Column G where Column A is "NO".
You can also put the above formula on any other sheet.
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.