Help with count formula please,

[Keith Blake]

OFFSET(C6,COUNT(C7:C33),0)

I am using this formula as part of a spreadsheet I am using for a social
golf club, it has 20 sheets, and this formula keeps track of how many games
an individual plays. It works well except for the fact if a player misses a
game the result (in C35 shows 0, as per the formula)
eg: c7 1 c8 2 c9 3 c10 4 and the result in c35 is 4 ( as I want)
but if c7 1 c8 2 c9 (no input,blank) c10 3 the result in c35 is 0 not 3
So what I need is to change the ,0) bit but I am not sure what with or how
to replace it so that it ignores a blank cell .........

Thanks for any help
Keith Blake
(e-mail address removed)

 

[Peo Sjoblom]

One way

=INDEX(C7:C500,MATCH(9.99999999999999E+307,C7:C500))

 

[Keith Blake]

Brilliant thanks,
Works great and it took less that 10 mins to get a reply...
Gotta love the internet !

Thanks again Peo