Percent problem

**Atomo** · 03-14-2009, 01:06 PM

Hey all,

I have the following:

Monday (1) = (A-3)
Tuesday (1) = (A-4)
Wednesday (1)= (A-5)
Thursday (1) = (A-6)
Friday (X) = (A-7)

Each time person shows up work, he gets number "1" in cell. If he doesnt, the cell is left empty. What function do i use to get the % number and how? Obvious answer is 80% in this case, as our person showed up 4/5 times to work.

Thanks

**zbor** · 03-14-2009, 01:13 PM

=countif(a2:a7;1)/counta(a2:a7)

**Atomo** · 03-14-2009, 01:57 PM

It says 0... Could you explain what that "syntax" does so i could figure the problem?

Edit: i re-did my excel a bit, so i put:
=COUNTIF(F3:J3;1)/COUNTA(F3:J3)

It says: Formula omits adjacent cells

**zbor** · 03-14-2009, 02:22 PM

Maybe this "he gets number "1" in cell" confusing me... formula say:

count if from F3 to J3 contains number 1 / count all cells that have data from F3 to J3

**Atomo** · 03-14-2009, 02:27 PM

I left something really important out, the cells can contain the next values:
0, 1, 3 and -3

Sorry

**Atomo** · 03-14-2009, 02:29 PM

I left something really important out, the cells can contain the next values:
0, 1, 3 and -3

Sorry

Edit: So in other words, if the cell has values which i mentioned above, it would count as if hes working. If the cell is empty, it doesnt count as work. It would be simple if excel could detect if there is anything in cell. Is that possible?

**zbor** · 03-15-2009, 04:39 AM

How about this: =COUNTIF(H6:P6;"<4")/5

Formula would include all above values (0,1,3,-3 since they all are <4) and divided by 5 (days at week).

If you put 0 in cell formula will count it. If you put blank, it won't.