Count occurence with user defined upper&lower limit.

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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.

 

[Leo Heuser]

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.

 

[Leo Heuser]

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.

 

[Peo Sjoblom]

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

 

[Peo Sjoblom]

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

 

[Guest]

Dear Dave,

I think i din't get my question asked nicely ...

Lets start again.

I have a series of data:
1,1,1,2,2,2,3,3,4,4

Under normal circumstances, if i want to group the data as table below, it
would like this:

Value range Occurence
1-2 =COUNTIF(A1:A10,">=1") -
COUNTIF(A1:A10.">2")
2-3 =COUNTIF(A1:A10,">=2") -
COUNTIF(A1:A10.">3")

And what if i want a table as per below which allow user to key in their
lower & upperlimit and i can get the occurence ultimatly as above

Value Range Occurence
lower Upper
1(user key in) 2(user key in) =(*need formula here*)
2(user key in) 3(user key in) =(*need formula here*)


Hope i get it clear.
Hope to hear from your favorable response soon.
Thanks!

-Chan

 

[Guest]

Dear Dave,

I think i din't get my question asked nicely ...

Lets start again.

I have a series of data:
1,1,1,2,2,2,3,3,4,4

Under normal circumstances, if i want to group the data as table below, it
would like this:

Value range Occurence
1-2 =COUNTIF(A1:A10,">=1") -
COUNTIF(A1:A10.">2")
2-3 =COUNTIF(A1:A10,">=2") -
COUNTIF(A1:A10.">3")

And what if i want a table as per below which allow user to key in their
lower & upperlimit and i can get the occurence ultimatly as above

Value Range Occurence
lower Upper
1(user key in) 2(user key in) =(*need formula here*)
2(user key in) 3(user key in) =(*need formula here*)


Hope i get it clear.
Hope to hear from your favorable response soon.
Thanks!

-Chan