Count Non-Blank Cells in a Range

Robb · May 20th, 2002, 10:03 AM

I am have brain freeze, what's the formula guys?

sann0638 · May 20th, 2002, 10:09 AM

=countif(range,"")

Robb · May 20th, 2002, 10:11 AM

Thanx, but that just counts the BLANK cells. I was looking for NONBlank cells.

sann0638 · May 20th, 2002, 10:15 AM

apologies.

=countif(range,"<>")

Robb · May 20th, 2002, 10:18 AM

Thanx for your time.
I also figured another way around it before I read your last post. It goes as follows:

(Number of rows in my NamedRange = 220)

=(220)-COUNTBLANK(STYLE)

Aladin Akyurek · May 20th, 2002, 10:20 AM

Quote:

On 2002-05-20 09:18, Robb wrote:
Thanx for your time.
I also figured another way around it before I read your last post. It goes as follows:

(Number of rows in my NamedRange = 220)

=(220)-COUNTBLANK(STYLE)

I think the COUNTIF version is better.

Jay Petrulis · May 20th, 2002, 10:23 AM

=COUNTA(YourRange)

danam531 · May 20th, 2002, 10:32 AM

yes, counta is the easiest! just type = COUNTA(Range)

May 20th, 2002, 10:03 AM	#1
Robb Board Regular Join Date: Feb 2002 Location: Winnipeg, Manitoba, CANADA Posts: 130	I am have brain freeze, what's the formula guys? __________________ Thanx.

May 20th, 2002, 10:15 AM	#4
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	apologies. =countif(range,"<>") __________________ Regards, Mike.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 10:09 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	=countif(range,"")

May 20th, 2002, 10:11 AM	#3
Robb Board Regular Join Date: Feb 2002 Location: Winnipeg, Manitoba, CANADA Posts: 130	Thanx, but that just counts the BLANK cells. I was looking for NONBlank cells.

May 20th, 2002, 10:18 AM	#5
Robb Board Regular Join Date: Feb 2002 Location: Winnipeg, Manitoba, CANADA Posts: 130	Thanx for your time. I also figured another way around it before I read your last post. It goes as follows: (Number of rows in my NamedRange = 220) =(220)-COUNTBLANK(STYLE)

May 20th, 2002, 10:23 AM	#7
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	=COUNTA(YourRange)

May 20th, 2002, 10:32 AM	#8
danam531 New Member Join Date: May 2002 Posts: 40	yes, counta is the easiest! just type = COUNTA(Range)