Number of times Greater than or equal to 100 but less than 150

[James8761]

Hi All,

I am trying to put in a formula as above. Numbers between 80 and 170 are in Cells A2:A147.

I want to look at Cells A2:A147 and count the number of times a figure of between 100 and 149 occurs.

Thanks for any help

 

[Repush]

=countif(a2:a147,"<150")-countif(a2:a147,"<100")

 

[Joe4]

You can do it all in one formula with COUNTIFS.

=COUNTIFS(A2:A147,">=100",A2:A147,"<150")

See: https://support.office.com/en-ie/article/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842

 

[James8761]

Thanks both, much appreciated!