Counting items in a list
The last two digits appear to have gone astray:
=SUM((A1:A51)*(A1:A5<100))
That is more like it.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
"Martin Fishlock" wrote:
Try the following as an array formula:
=SUM((A1:A51)*(A1:A5<1))
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
"Matt" wrote:
That would work. However, I would like to use a formula syntax that is
similar to the original. I don't understand why that particular
formula is not working.
Thanks!
Ron Coderre wrote:
Try something like this:
With your posted example data in A1: A5
This formula returns the count of items between 1 and 10, exclusive
B1: =COUNTIF(A1:A5,"1")-COUNTIF(A1:A5,"=10")
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Matt" wrote:
Say if have a list of numbers in cells A1:A5
12
99
9
3
60
I would like to count the number of values that are between 1 and 10
exclusive using a formula something like this:
{=SUM(IF(AND(A1:A51,A1:A5<100),1,0))}
However I always get 0 for the answer. Any ideas?
|