Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Windows 7 > using countif on figures made up of LEFT...,

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

using countif on figures made up of LEFT...,

Reply to Message Icon

Name: Alison Burke
Date: June 3, 2009 at 11:25:00 Pacific
OS: Windows XP
Subcategory: Software Problems
Comment:

using countif on a column made up of figures from using the LEFT(cell ref..). I have column M that is picking up the left hand digit from column G. I am then using the countif on column M and it is not working. Can anybody tell me why. I have checked the formatting already.

Thanks



Sponsored Link
Ads by Google

Response Number 1
Name: Mike (by mmcconaghy)
Date: June 3, 2009 at 12:06:50 Pacific
Reply:

Worked for me.

Column G

cell g1 12345
cell g2 23456
cell g3 12345

Column M
cell m1 formula =left(g1,2) gave 12
cell m2 formula =left(g2,2) gave 23
cell m3 formula =left(g3,2) gave 12

Cell M5
=countif(M1:M3,23) gives 1

Cell M6
=countif(M1:M3,12) gives 2

What kind of error are you getting?


Also for future reference, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/


0
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows 7 Forum Home


Sponsored links
Ads by Google


Results for: using countif on figures made up of LEFT...,
Programs to run in Win 7 www.computing.net/answers/windows-7/programs-to-run-in-win-7/185.html

AOL on IE8 www.computing.net/answers/windows-7/aol-on-ie8/500.html

Welcome to Windows 7 www.computing.net/answers/windows-7/welcome-to-windows-7/2.html