Create totals using drag down

[Danny54]

Good Afternoon

Could a formula be created to count occurrences of values in ranges and list the occurrences at the conclusion of values in column a.
example - looking for a total count of Crits would find 2 values that fall in the Ranges value of 900-1000 [the ones showing 1000]
Next looking for the highs (ranges 600-899) finds three values, 600, 700, 700 and so on

If a formula couldn't be create a macro could be used.

Thanks

Count		Ranges	Desc
600​		900-1000	Crit
1000​		600-899	High
700​		300-599	Med
560​		0-299	Low
700​
1000​
55​
2 - Crit 3 - High 1-Med 1-Low

 

[iggydarsa]

=COUNTIF(A:A, ">=900") & " - Crits"

=COUNTIFS(A:A, ">=600", A:A, "<900") & " - High"

=COUNTIFS(A:A, ">=300", A:A, "<600") & " - Med"

=COUNTIF(A:A, "<300") & " - Low"

 

[Danny54]

Thanks