If you try to use an aggregation such as sumif, countif, averageif, etc in a calculated column, you'll have the following error
"Wrong arguments for function: countif"
Indeed, right now, we have a technical limitation preventing us to support this. We're working on it though! ✌️