Re: excel questions
Lisle, Ted (CHFS DMS)
A straight range would also work, if there are any values in that range at all. That always worked for me when I was figuring grades.
toggle quoted messageShow quoted text
Ted
Original Message
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dave Carlson Sent: Friday, November 18, 2016 3:47 PM To: main@jfw.groups.io Subject: Re: excel questions Joe, There may be another function for averaging that avoids any zero values. Otherwise, create a formula that first finds all nonzero values, and then adds them up and divide by the total count of nonzero values. That takes a few functions, but workable. I recall doing something like this several years ago. First try to find a builtin function that averages all nonzero values. Also, check the Excel help function to look for any websourced solutions to your question. Farfar Dave Oregonian, woodworker, Engineer, Musician, and Pioneer  Original Message  From: <stintonjoe@...> To: <main@jfw.groups.io> Sent: Friday, November 18, 2016 12:40 Subject: Re: excel questions ok I'm now trying to get excel to tell me the AVERAGE of cells B102 D102 F102 G102 H102 I102 J102 K102 L102 M102 the problem being at the moment not all the cells have a number in them and all it says is div 0,but as time goes on they will all have a number in them. the formula i have tried is =AVERAGE(B102 D102 F102 G102 H102 I102 J102 K102 L102 M102) but with this fromaler as far as I can tell the advridge of these numbers all need a number in for it to show anything. for example if b 102 and f 102 have numbers in I still get nothing in the average cell. well I hope you can make some sort of sense out of my ramblings. cheers Joe cheers Joe Original Message  From: Ann Byrne Sent: Friday, November 18, 2016 1:19 PM To: main@jfw.groups.io Subject: Re: excel questions I you want to use the formulas dialog, press ALT+m, then f. Tab to the categories and choose all, then tab once more and find average. You can fill in range after range after range, tabbing from one to the next. Tabbing will *never get you to the okay button, because it just allows for another range. Pressing enter might do the okay, or shift+tab till you get back to okay. At 03:27 AM 11/18/2016, you wrote: hi all

