"Chan" skrev i en meddelelse
...
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.


Chan

The proper syntax is:

COUNTIF(A1:J1,"="&A5) - COUNTIF(A1:J1,""&B5)

The string "=A5" Excel "sees" as 4 separate characters, not as a cell
reference.


--
Best regards
Leo Heuser

Followup to newsgroup only please.