Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Criteria for Countif | Excel Worksheet Functions | |||
COUNTIF statement with 3 criteria checks | Excel Discussion (Misc queries) | |||
COUNTIF with two criteria | Excel Worksheet Functions | |||
Countif w/ Multiple Criteria | Excel Worksheet Functions | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions |