• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 640
  • Last Modified:

Countif in Excel

I want to do a countif that will count all cell in the range C2:C26 that have anything in them. Any idea how to do this? I though it was "*" but that is only for an astrick.
0
cansevin
Asked:
cansevin
3 Solutions
 
Saqib Husain, SyedEngineerCommented:
Try

=COUNTIF(C2:C6,"<>")
0
 
livianCommented:
You can use =COUNTA(C2:C26), and you will get the number of cells that are not empty.
0
 
dubadayCommented:
If you want to count all cells with anything in them, you do not need countif. Just use =COUNT(C2:C26)
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now