On 06/05/2015 16:02, JimK wrote:
http://www.excelfunctions.net/Excel-...-Function.html

Thanks Jim although I still cant work it out from that.
I need to add something to my formula so that a blank cell does not
contain an invisible zero which is then picked up and used to count my
averages. Excuse my terminology but not too clever with excel stuff.