Re: excel questions
Dale Alton <blinkydale@...>
That shouldn't matter. I tried it by putting in random numbers in column
toggle quoted messageShow quoted text
a1:a10. I put the formula =average(a1:a10) in cell a11 and it came up with an average. Not all cells had numbers in them. If you don't want the error showing up you can try =ifError(average(a2:a101),""). The formula will show a blanck cell if there is an error. As far as getting it to the other cells I would just do a copy paste. I hope this helps. Denver Dale
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of stintonjoe@... Sent: Friday, November 18, 2016 1:41 PM To: main@jfw.groups.io 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
|
|