Hello,

I am trying to obtain how many cells contain values greater than 20 in a range depending on whether it is filtered or not, but I think the command is also counting cells that do not have numbers. The cells in the range (column S) containing the numbers are generated using an =if formula to only display the figures when a condition is met in a relating cell, or nothing using "". The formula works counting numbers less than 20 used in another cell, but when I try to count entries greater than 20 the problem occurs.

The formula I am using is as follows: =SUMPRODUCT(SUBTOTAL(3,OFFSET($S:$S,ROW($S:$S)-MIN(ROW($S:$S)),,1))*($S:$S>20)). where column S contains the figures.

Can anyone help me with this one.

Thank you.