I need help with a formula that will average the last 8 cells with non-blank values in the range e3:e20. (There will be blanks and there may be less that 8 cells with values, in which case, I need it to average what's available.) I also need do sum the entries in g3:g20 with the same possibilities.
I've tried tweaking everything I found on the site so far, and no luck!
Any ideas?[/b]
I've tried tweaking everything I found on the site so far, and no luck!
Any ideas?[/b]