SOLVED

Trying to get a formula for "if a value in cells M9:M76 then add a count of 1 in cell M79"

Copper Contributor

I'm Trying to get an automatic headcount. Starting with a blank excel sheet (it has some formulas, etc. but no data). As a players scores are added, column "M" gets populated. All I want is if there is a value in the "M" cell, give me (add 1) in cell M79.

2 Replies
best response confirmed by rjohns05 (Copper Contributor)
Solution
I think one of these should work for you. Count will count numbers in a range (ignoring text) and counta will count numbers, text (and formulas that return ""), etc.

=COUNT(M9:M76)
=COUNTA(M9:M76)

@JMB17 

That worked. Thanks so much for the rapid response. Now my golfing buddies will see their scores even sooner!

1 best response

Accepted Solutions
best response confirmed by rjohns05 (Copper Contributor)
Solution
I think one of these should work for you. Count will count numbers in a range (ignoring text) and counta will count numbers, text (and formulas that return ""), etc.

=COUNT(M9:M76)
=COUNTA(M9:M76)

View solution in original post