# wrong formula results in Calc or I am doing something wrong? [closed]

I have different grades (5, 6, 7, 8, 9 and 10) in sheet 1. I use simple function "countif" to count grades and then to calculate percentage. However, this happened twice (see photo).

When second grades is entered in sheet 1, everything is working fine (even after I delete that grade, and still have only one grade). Any idea why is this happening?

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-19 09:37:34.755801

How do you enter the numbers is in column C? By hand exact as they appear, calculated and displayed as "0" or "1". If they are calculated and rounded to 0, 1 you might have some real value there that give you a result <>0.

( 2014-02-08 23:56:12 +0200 )edit

Can you include an example of what is in the "Broj" (COUNTIF) column? Would seem like the displayed zero is not actually a zero or that the COUNTIF is not returning what is expected? What is the format of the "Broj" column? EDIT: Did not see the comment by @horst. My question is the same, just worded differently.

( 2014-02-09 00:13:15 +0200 )edit

This is the column C7. "=COUNTIF($Ocjene.$AB$4:$AB\$173;B7)" and B7 is just number "7". I've already had an Calc document with two sheets (Ocjene and Statistika)... after an makeup exam, I deleted all grades from students and then started entering the new one... and that is when it happened.

( 2014-02-09 09:56:48 +0200 )edit

I will check if it's possible to reproduce this error and then upload file here

( 2014-02-09 09:58:23 +0200 )edit

Sort by » oldest newest most voted

Hi @Ljiljan, try to recalculate the whole document by pressing Shift+Ctrl+F9. There might be old data left over.

more