Prev: Round
Next: Filter formula
From: clbritt76 on 26 Mar 2010 09:14
Ok so I have a column with values in it. Say A4:A12, the values entered will
always be 1, 2, 3, or 4. I need a formula that will calculate the % that say
a 1 appears in that range and I need a formula that will calculate the total
number of 1s in that range.

Thanks!
From: Fred Smith on 26 Mar 2010 09:22
=countif(a4:a12,1)/count(a4:a12)

Format as percent

Regards,
Fred

"clbritt76" <clbritt76(a)discussions.microsoft.com> wrote in message
news:28AFAD8A-88BC-4151-AE7F-5463AA6E9B68(a)microsoft.com...
> Ok so I have a column with values in it. Say A4:A12, the values entered
> will
> always be 1, 2, 3, or 4. I need a formula that will calculate the % that
> say
> a 1 appears in that range and I need a formula that will calculate the
> total
> number of 1s in that range.
>
> Thanks!

From: Mike H on 26 Mar 2010 09:23
Hi,

To count the ones
=COUNTIF(A4:A12,1)

% of ones
=COUNTIF(A4:A12,1)/9

Format this one as %
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"clbritt76" wrote:

> Ok so I have a column with values in it. Say A4:A12, the values entered will
> always be 1, 2, 3, or 4. I need a formula that will calculate the % that say
> a 1 appears in that range and I need a formula that will calculate the total
> number of 1s in that range.
>
> Thanks!
 | 
Pages: 1
Prev: Round
Next: Filter formula