Using countif on a range where numbers in that range have to be altered

Afternoon, I have a range of cells (L1:T1) each of which contains a number (a gross value). The net value is the gross value minus a number in A3, but the net value itself is not stored anywhere - only the gross value.

What I'd like to do is to count how many values in the range L1:T1 which, when A3 is deducted, would be less than the value in A1.

Is that possible? I'd rather not have to do another range with the net values as it would be *a lot* of changes. I could easily do this in VB but I've been banned from it.....

Thanks in advance.

Please attach a sample Excel workbook - details of how to do this are given in the yellow banner at the top of the screen.

Pete

Thank you! That worked a treat.

Apologies that I didn't attach a sample sheet - I thought it was a simple enough query and have only just got round to revisiting this to post one but the question is answered now.