I have a column where entries are made every day. Sometimes there is a number, most times it's blank. I want a formula that counts only the last five entries made, no matter how far apart they are. For example entries were made for b1, e1, g1, h1, m1 with everything else being blank. I want to get the average for the five cells with numbers.
Thanks
Kevin
Thanks
Kevin