Search results

Your formula works great except that it returns an error if there are blank cells in the range. Can it be adjusted to take this into account ?

No I forgot the = and, yes, I used yours in the end. I know the rest so I can do the averages in far less time. And I've got 30 years worth to do !

Done it now. Thanks.

You may be on the same course as me in Hove.

Thanks. When I enter the formula it just enters it as text rather than formula. I hold the CTRL+SHIFT down then press ENTER at the same time.

Thanks. So what formula do I use to instruct Excel to count the amount of cells with * in them ? Also, how do I get Excel to total the amount of runs in a column that includes runs with * against them ? E.g: A2 45 A3 32* A4 12 Total (formula) Should be 99- the problem being that Excel may...

I'm trying to work out the best criteria whilst only using one column for batsman's match scores. Asterisk would be ideal, but might screw up the totaling function.

Yes. I'd rather just run a single linear column where something can identify that the innings was 'not out'.

Another question on Excel for much needed help... I need to put together comprehensive averages for my village cricket club. I want to know a formula that will recognise an innings that the batsman was 'not out' in when calculating completed innings- without having to produce another column...