darn CountIF

clinteastwood09

New Member
Joined
Sep 20, 2006
Messages
2
I've got a pretty (what i would think to be easy issue).

I was trying to use countif to count all the rows in a sheet minus the "blank rows". Im not counting the values INSIDE the rows.. just the rows .

here is the formula.. i thought would work.

=COUNTIF(I1:I1000,'-' COUNTBLANK(I1:1000))

can anyone give me insight into why this doesnt work????
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
I've got a pretty (what i would think to be easy issue).

I was trying to use countif to count all the rows in a sheet minus the "blank rows". Im not counting the values INSIDE the rows.. just the rows .

here is the formula.. i thought would work.

=COUNTIF(I1:I1000,'-' COUNTBLANK(I1:1000))

can anyone give me insight into why this doesnt work????

One of:

=COUNTIF(I1:I1000,"?*")

=COUNT(I1:I1000)+COUNTIF(I1:I1000,"?*")
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

=COUNTA(I:I)

Will count only non blank rows.

HTH,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,111,908
Messages
5,541,531
Members
410,547
Latest member
htran4
Top