Solved

# Countif in Excel

Posted on 2012-04-11
629 Views
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
Question by:cansevin

LVL 43

Assisted Solution

Saqib Husain, Syed earned 167 total points
ID: 37836036
Try

=COUNTIF(C2:C6,"<>")
0

LVL 3

Assisted Solution

livian earned 166 total points
ID: 37836057
You can use =COUNTA(C2:C26), and you will get the number of cells that are not empty.
0

LVL 1

Accepted Solution

ID: 37836548
If you want to count all cells with anything in them, you do not need countif. Just use =COUNT(C2:C26)
0

## Featured Post

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…