# Any Excel gurus out there?

**URL:** <https://forums.suse.com/t/any-excel-gurus-out-there/22699>\
**Category:** Chatting over the Back Fence\
**Created:** [June 1, 2012, 10:40pm UTC](https://forums.suse.com/t/any-excel-gurus-out-there/22699 "2012-06-01T22:40:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![System1](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@System1](https://forums.suse.com/u/System1)\
**Post date:** [June 1, 2012, 10:40pm UTC](https://forums.suse.com/t/any-excel-gurus-out-there/22699/1 "2012-06-01T22:40:05Z")

</div>

Just wondering why I cannot get countif function to work.

A

04  
03  
09  
01  
12  
02  
06  
etc…

=COUNTIF(A1:A152,"=09") always results in 0.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\
**Post date:** [June 1, 2012, 10:42pm UTC](https://forums.suse.com/t/any-excel-gurus-out-there/22699/2 "2012-06-01T22:42:54Z")

</div>

Nevermind, apparently the data had some invisible padding after each number  
so it wasn’t a match.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\
**Post date:** [June 1, 2012, 10:44pm UTC](https://forums.suse.com/t/any-excel-gurus-out-there/22699/3 "2012-06-01T22:44:20Z")

</div>

On 01/06/2012 20:40, GofBorg wrote:[color=blue]

> Just wondering why I cannot get countif function to work.
> 
> A
> 
> 04  
> 03  
> 09  
> 01  
> 12  
> 02  
> 06  
> etc…
> 
> =COUNTIF(A1:A152,“=09”) always results in 0.[/color]

This is because that COUNTIF is looking for a text string of =09  
If that column data really is text, then simply change it to  
=COUNTIF(A1:A152,“09”)

## Michael

“I’ve got the key to the gates of paradise, but I’ve got too many legs!”

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\
**Post date:** [June 1, 2012, 10:54pm UTC](https://forums.suse.com/t/any-excel-gurus-out-there/22699/4 "2012-06-01T22:54:27Z")

</div>

> This is because that COUNTIF is looking for a text string of =09[color=blue]  
> If that column data really is text, then simply change it to  
> =COUNTIF(A1:A152,“09”)[/color]

Actually no, there are numerous correct syntax for matching.  
Yours is one, mine is another and there are other acceptable queries.  
I wouldn’t have guessed it was correct either, but I just read up on  
the subject ant to me it is easier to read and understand the logic.  
That’s why I added the equals. Turned out the issue was a hidden  
character from the data import. I got rid of it throughout and now  
it’s all peachy. Thanks for the assist though!
