Excel excel help please

E

elyodjod

Joined
Oct 29, 2009
Messages
2
Reaction score
0
i am new to this and was looking for some help. i have a string of 12 numbers, which are .5, .5, 0, 1, 1, 0, .5 1, 1, 1, .5, 0 all in different cells. what i am attempting to do is find a formulae for a single cell answer, which adds up the number of 0.5's(i.e 4) adds this to the number of 1's then divides this by the number of numbers(12) and expresses this as a percentage. thanks in advance to anybody who can help
 
=SUM(B5:B16)/12
is a simple answer with B5:B16 the data range of your numbers
This cell can be put anywhere
 
thanks, but it does not solve the problem. it is the sum of the number 1's, but it is the amount of 0.5's(4, not the sum 2) which i am trying to find a way around
 
Hey you can use the worksheet function countif to count the number of occurrence and it becomes easy.

=(countif(a1:a12,0.5)+countif(a1:a12,1))/12

Now modify it to express this as a percentage

=(countif(a1:a12,0.5)+countif(a1:a12,1))/count(a1:a12) & "%"

Is it what you want?
 
Back
Top