Counting and returning the value... Please help!!

[Guest]

Ok
I don't claim to be a smart person when it comes to math, I hope someone is out there that can help

I have a list of values. I am trying to write a statement that would look for values <> I am trying to decipher how many 1's, 2's 3's etc. there are and list the Values that are found greater than 3 times for example in a results cell .

Example..

A10 = 10, B10 = 3 (the number of 10's found from a list of values) the number 10 was found in a list of values 3 time
A11 = 11, B11 = 1 (the number of 11's found from a list of values) the number 11 was found in a list of values 1 tim

the statement - If VALUE(b1:b2) =< 3 then cut and paste the value to A100(the summary cell); if VALUE = > 3 then ignore or skip

Hope this makes sense... Please post any ideas for a formul

Thanks in advance

 

[Roger Govier]

Hi Bryan

In cell A100 enter
=SUMIF(B1:B99,"<=3")

--
Regards
Roger Govier

Ok,
I don't claim to be a smart person when it comes to math, I hope someone is out there that can help!

I have a list of values. I am trying to write a statement that would look

for values <> I am trying to decipher how many 1's, 2's 3's etc. there are
and list the Values that are found greater than 3 times for example in a
results cell .

Example...

A10 = 10, B10 = 3 (the number of 10's found from a list of values) the

number 10 was found in a list of values 3 times

A11 = 11, B11 = 1 (the number of 11's found from a list of values) the

number 11 was found in a list of values 1 time

the statement - If VALUE(b1:b2) =< 3 then cut and paste the value to

A100(the summary cell); if VALUE = > 3 then ignore or skip.

 

[Guest]

Thanks Roger! I'll give it a try!