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.


Just add an ampersand

=COUNTIF(A1:J1,"="&A5)- and so on

Regards,

Peo Sjoblom