Excel Help

[Hughesy]

Please can someone help.

I have a list of numbers - i.e.
20
22
27
29
32
34
26
25
27

I now need a formula that will show me how many would be between 26-30. I know you can add a cutsom filter to do a count that way, but ideally I need it as a formula.

 

[SillyJokes]

Something like
Countif

 

[Hughesy]

Im sure it is an CountIF or a sumIf but im after a more specific answer if possible.

It as an array formula?

 

[spreadsheetsdirect]

Try =SUMPRODUCT((range>=26)*(range<=30))

 

[Hughesy]

Top man! Thanks

 

[ExpandOnline]

I think you need to go on an Excel course - 2nd excel question in 2 days

 

[Hughesy]

If there was a course that suites my needs I would.

I can do all the nested if statements, lookups, pivots etc, its just this sumproduct function and Arrays i havent come accross before.

Iv mastered them now though - quick learner.