I'm not at a PC with Excel on...

but

=Sum(A1:A20)/Countif(A1:A20)""

might work.

MB

Posted By: Mighty Boosh, Oct 8, 17:23:31

Follow Ups

That should read.... greater than less than ""
Posted By: Mighty Boosh, Oct 8, 17:26:34

Reply to Message

Written & Designed By Ben Graves 1999-2025