hey everyone, i need some help here
i am working on some data where i have multiple columns in the excel worksheet.
i want to give a range to individual column and want to calculate the no of time
data cross their respective ranges.

for example in column A i have 10 nos of numerical values (12, 13, 7, 25, 18, 9, 14, 11, 29, 21).
now i give a range lets say 10 to 20. so i want to calculate the cases where the value is not in
this range 7,25,9,29,21(5 cases). is there any way i can do it in excel.

thanks and regards.