COUNTIF criteria
Thanks for the reply Biff.
I used using this formula:
=COUNTIF(A1:A13,"=41")-COUNTIF(A1:A13,"<=50")
It gives me an error which says not to use "-" in the formula. Any
ideas?
Roohbir
Biff wrote:
Try this:
Numbers in the range A2:A14.
=COUNTIF(A2:A14,"=41")-COUNTIF(A2:A14,"50")
Better to use cells to hold the variables:
C2 = 41
D2 = 50
=COUNTIF(A2:A14,"="&C2)-COUNTIF(A2:A14,""&D2)
Biff
"roohbir" wrote in message
ups.com...
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
|