Quote:
Originally Posted by uk_dave&gill
I love Excel! So much time can be happily wasted coming up with formulas and macros to do stuff that you could achieve manually if you could be bothered, but where's the fun in that!
Seem to recall helping you with a time/expenses spreadsheet a while back Harry? By a while back, I mean around 6 years!
|
Have a vague recollection of that. My memory is not what it used to be, but then it never was
Yes I have spent endless, not entirely wasted, hours on this spreadsheet. I used to love playing about with numbers in my latter years at school, when all we had was pen, paper and log tables. It was a revelation when I went to college and I found there were easier ways, like slide-rules. As soon as calculators came out, I bought a then very expensive used LED display HP, driving 50 miles to collect it. That took me into home built micro-processor systems and a bit of programming. I sort of lost interest when everyone had a PC.
I show Jane the spreadsheet, as we both share the bills and her eyes just start rolling
In an Excel spreadsheet, what is the correct formulae to use for a column of figures to get an average value, but ignoring/ not counting the rows into which no numbers have yet been entered please?
Column is Y, the rows I am interested in are 5 to 60, there is only data so far entered into rows 5 to 18, so I want it to provide an average just those 13 rows, incrementing as more data is added in the rest?
=AVERAGE(Y5:Y60) provides an average value for all of the rows. I want to not count the ones with no data in them.
Sorted! - =AVERAGEIF(Y5:Y60,">0")
Sorry, I have just noticed I have somehow managed to post this in the wrong forum, perhaps a mod could move it to the Technology forum please?