Calculating percent of times a value is in a column and total #

  • Thread starter Thread starter clbritt76
  • Start date Start date
C

clbritt76

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!
 
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.
 
Back
Top