Countif (in finnish laske.jos)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:

A B
C
11.11.2002 0:01:00 11.11.2002 0:01:00
=COUNTIF($A$1:$A$;B1)
11.11.2002 0:01:00 11.11.2002 0:02:00
=COUNTIF($A$1:$A$;B2)
11.11.2002 0:02:00
11.11.2002 0:03:00
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
 
Sorry the malformatting: C includes the countif functions, B íncludes the
comparing value and A includes the data to look at.

"TT" kirjoitti:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif (same as previous) 2
Countifs with different restrictions 1
Conditional Time Calculation 10
Excel Need Countifs Formula Help 0
countifs Function not giving desired result with date criteria 2
Countif with two criteria 2
separating date and time 5
countif where condition should be met 3

Back
Top