Anyone have any suggestions how I might be able to do the following:
I'm have a column "K3 thru K24" which depicts data ranging from zero to 60, etc. What I'd like to do is be able to take the data and only obtain the average of the data of anything greater than zero. I don't want anyone with zero's to be averaged into the formula and I need this formula to adjust if I filter my data as well. I hope that makes sense. I'd appreciate anyone's advice or tips!
Bookmarks