Count occurence with user defined upper&lower limit.
All you need to do is enter =COUNTIF(A1:A10,B1) for your lower bound and
=COUNTIF(A1:A10),B2) for your upper bound, assuming that the range is in
A1:A10 and your lower bound cell and upper bound cell are in B1 and B2
respectively.
"Chan" wrote:
I would like to know how to count occurence in a column/row of data with
user define-able of its upper & lower limit in a table format.
Detail as illustrated below,
series data:
1,1,2,2,3,3,4,4,5,5
lower limit upper Limit occurence
2 (user key in) 4 (user key in) (*need formula here to get
"4")
It was unachievable by using COUNTIF command since i can't assign a cell
value in to COUTIF(A1:J1,"=A5") - COUNTIF(A1:J1,"B5") as e.g
Thanks and hope hear from yours reply soon.
|