Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF( {local cells}, {number from other sheet})
We have a group at work that is working with a CSV file that has been saved
with a .XLS extention. They are working this worksheet in Excel 2007, and are having problems with COUNTIF. The quandry is that they using the COUNTIF variables from two separate sheets, and trying to get acurate counts. The situation is as such: Sheet 1 Sheet 2 Formula A1 12450903093004001 12450903093004001 COUNTIF([Sheet 1]$A$1:$A8, A1) A2 12450903093004001 12450903093004002 COUNTIF([Sheet 1]$A$1:$A8, A2) A3 12450903093004001 A4 12450903093004001 A5 12450903093004002 A6 12450903093004002 A7 12450903093004002 A8 12450903093004002 The Results say there are 8 of each number. Not 4 of each as there really are. I was thinking it was because it was being saved as a CSV with all the numbers are "numbers as text", but I tested with others sheets and it should be a working formula. Has anyone else seen this problem and able to lend a hint? Thanks, ShadoShryke |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif with two conditions and cells one a number and other text | Excel Discussion (Misc queries) | |||
Select cells according to row number in different sheet | Excel Discussion (Misc queries) | |||
Finding Number of cells in a column of other sheet having a specific word in them | New Users to Excel | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
In COUNTIF function, how do I count the number of cells which con. | Excel Worksheet Functions |