frequency function with decimals

  • Thread starter frequency function with decimals
  • Start date
F

frequency function with decimals

I have a set of 365 different numbers and some of the numbers are decimals
(i.e.: 921.74). How do I use the frequency function to determine how many
numbers in my set fall into certain categories that I want to create. For
example, if I want my category to include all the numbers in my set greater
than but not equal to 110 and less than but not equal to 230 and some of the
numbers in my set are decimals how do I do this???????????????
 
T

T. Valko

One way:

=COUNTIF(A1:A365,">110")-COUNTIF(A1:A365,">=230")

Or, using cells to hold the boundaries:

C1 = 110
D1 = 230

=COUNTIF(A1:A365,">"&C1)-COUNTIF(A1:A365,">="&D1)


--
Biff
Microsoft Excel MVP


"frequency function with decimals" <frequency function with
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top