View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roohbir roohbir is offline
external usenet poster
 
Posts: 9
Default COUNTIF criteria

I have the following data:
70
80
71
71
66
83
70
77
79
65
62
57
50

I want to use the COUNTIF function to calculate the no. of times
numbers occur in a range. For example how many numbers are between
41-50. The criteria could be something like =41 "to" <=50. But how do
i properly format it.
If COUNTIF cannot be used for this, other suggestions would be welcome.
Actually I want to make a pie-chart or bar-graph chowing this info.
Like how many occurences are within 41-50, 51-60 and so on.
Thanks in adavnce.

Roohbir