match formula only on visible rows

[Alina Loredana]

Hi all,

i'm trying to write a formula that searches a value in a range, the problem being that the range may or may not contain hidden rows. I need it to sum up values only on visible rows and only if it does not find a specific value in a range, also only on visible rows. If it does find the specific value, i need it to return "salary on 5000"

see sample file attached. depending on value selected in I2, rows are shown/hidden. I need the formula in I14 to work only on visible rows
I used subtotal, but I need match to work similar as well.

=IF(ISERROR(MATCH(5000,F3:F7,0)),SUBTOTAL(109,F3:F7),"salary of 5000")

Thank you in advance :D