Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif (same as previous)
When trying to count the number of same values in one column Excel does count
a number of these, but then gives only zero to answer value. It is like this: column A column B 11.11.2002 0:01:00 11.11.2002 0:01:00 11.11.2002 0:01:00 11.11.2002 0:02:00 11.11.2002 0:02:00 11.11.2002 0:03:00 etc. column C =COUNTIF($A$1:$A$lastvalue;B1) =COUNTIF($A$1:$A$lastvalue;B2) etc. On count 1 answer should be 2 (there is 2 times cell matching cell B1) On count 2 answer should be 1 (there is 1 times cell matching cell B2) etc. But Excel (version 2002 SP3) does this randomly and gives answers mostly zero when copying the function in column C down. What to do ? Thanks, TT |
#2
|
|||
|
|||
Try:
C1: =COUNTIF(A:A;B1) and copy down. IF that doesn't work, are you sure all your data is entered as date/times rather than text (or, conversely, text rather than date/times?)? In article , "TT" wrote: When trying to count the number of same values in one column Excel does count a number of these, but then gives only zero to answer value. It is like this: column A column B 11.11.2002 0:01:00 11.11.2002 0:01:00 11.11.2002 0:01:00 11.11.2002 0:02:00 11.11.2002 0:02:00 11.11.2002 0:03:00 etc. column C =COUNTIF($A$1:$A$lastvalue;B1) =COUNTIF($A$1:$A$lastvalue;B2) etc. On count 1 answer should be 2 (there is 2 times cell matching cell B1) On count 2 answer should be 1 (there is 1 times cell matching cell B2) etc. But Excel (version 2002 SP3) does this randomly and gives answers mostly zero when copying the function in column C down. What to do ? Thanks, TT |
#3
|
|||
|
|||
Are the values in 'A' date-time stamps? They could be a fraction of a second off of the value in column B and they would not match. That would be the first thing I would check. That would explain the randomness that is happening. -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=319930 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table help:calculated field based on previous consecutive va | Excel Discussion (Misc queries) | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions | |||
combining countif formulas | Excel Worksheet Functions |