# of cells in range that have a value.

[catskid]

I would like to name a range of cells and enter data in some or all of the cells and then enter a formula next to the range that adds the number of cells that have a value. ie-- On my football stat sheet, I'll input yards for each carry in the range and then would like to put in a formula beside the range, that added up the cells with a value(actual carries during game).
Thanks for any help.
Mike

 

[wigi]

So, this is the COUNT function? Or am I missing something in your question?

 

[catskid]

I've never used the count function, I'll try now. I'll let you know soon.
Thanks
Mike

 

[catskid]

It works, THANKS!!!