Search results

Not sure this will work as the sumif formula won't recognise 108* as 108 and will ignore this value in the sum won't it? My guess you could use a User Defined Formula to have a little macro run through each value and create the average.

Thanks for the tip. I massively overuse VLOOKUP. I will check it out too.

CountIf or Countifs will be the likely formulae to use to give you the number of out innings to use as your divisor. Woking out what the criteria are for the formula will depend on how the rest of the data is represented. When looking at the spreadsheet can you identify if the innings was a...