Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: CountIF cell is Null

1. ## CountIF cell is Null

I am trying to do a COUNTIF the cell is not empty. Sometimes the value starts with a number but sometimes the value is a letter.
I figured out how do one or the other but not both.
=COUNTIF(E2:E65536,">""")
=COUNTIF(E2:E65536,">0")
Is is some how possible to combine them together.

BTW, The post should be countif cell is not null..
Last edited by Boriqua; May 8th, 2006 at 05:03.

Excel Video Tutorials / Excel Dashboards Reports

2. Super Moderator
Join Date
7th December 2005
Location
Hampshire, England
Posts
4,898

## Re: CountIF cell is Null

Originally Posted by Boriqua
I am trying to do a COUNTIF the cell is not empty. Sometimes the value starts with a number but sometimes the value is a letter.
I figured out how do one or the other but not both.
=COUNTIF(E2:E65536,">""")
=COUNTIF(E2:E65536,">0")
Is is some how possible to combine them together.

BTW, The post should be countif cell is not null..

=COUNTIF(E2:E65536,"<>""") will do it.

Excel Video Tutorials / Excel Dashboards Reports

3. ## Re: CountIF cell is Null

Thanks for the quick reply, But I am still having an issue it is counting the blank cell. Almost as if it would find the last used cell and make that the final value.

Excel Video Tutorials / Excel Dashboards Reports

4. Super Moderator
Join Date
7th December 2005
Location
Hampshire, England
Posts
4,898

## Re: CountIF cell is Null

Originally Posted by Boriqua
Thanks for the quick reply, But I am still having an issue it is counting the blank cell. Almost as if it would find the last used cell and make that the final value.
Ah, sorry, that's not what you wanted. This will work, but I expect someone will have a neater solution...

=SUM(COUNTIF(E2:E65536,">"""),COUNTIF(E2:E65536,">0"))
Last edited by ByTheCringe2; May 8th, 2006 at 05:41.

Excel Video Tutorials / Excel Dashboards Reports

5. ## Re: CountIF cell is Null

Thanx, That one worked.

Excel Video Tutorials / Excel Dashboards Reports

6. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,478

Hi,

=COUNTA(A:A)

7. ## Re: CountIF cell is Null

Excel Video Tutorials / Excel Dashboards Reports

8. Member
Join Date
9th August 2005
Posts
91

## Re: CountIF cell is Null

Or my favourite friend...

VB:
```=SUMPRODUCT(--(E11:E15<>""))

```

9. ## Re: CountIF cell is Null

Hate to Hijack, but what does the -- represent in a formula?

Excel Video Tutorials / Excel Dashboards Reports

10. Member
Join Date
9th August 2005
Posts
91

## Re: CountIF cell is Null

It changes a TRUE to a 1, or a FALSE to a zero...

http://www.ozgrid.com/forum/showthre...ighlight=MAXIF

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno