How to count a column with a condition on BIP Template

Hello All,

On RTF template, I have a column called "Days Pending". Days Pending can have any values from 10 to over a 100. I have another column called "Between 46 and 59 days".

For the second column, I need to write a formula that is similar to count(days_pending) when days_pending between 46 and 59. In other words, I need to count how many values of "Days Pending" column fall between 46 and 59 days. How can I do this on a RTF Template?

Any help is appreciated.

Thanks