Try SUMPRODUCT
=SUMPRODUCT(--(A1:A7="02"))
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of luvmymelody@yahoo.com
Sent: 09 April 2014 14:44
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] CountIf does not count numbers correctly
Hello all,
I have a column that is copied from an Access table. The format comes in as General. I have formatted it as Text. I am trying to get a count of the column based on the criteria.
there are values such as below. I have tried =countif(a1:a7, "02") and it counts all of the values. Is there a way to count the different values as separate values?
Thank You
Jim Wagner
02
02
02
2
2
02
2
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar