Forum Discussion
Solved
Trying to get a formula for "if a value in cells M9:M76 then add a count of 1 in cell M79"
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.
- 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)
2 Replies
- 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)
