counting functions - If Col A =5 and Col B < Col C

All,

I'm trying to find a function for the following statement:

=number of rows where columnA="value" AND columnB<ColumnC

So this formula would return 2 from the below table if the "value"=5...

X A B C
1 5 5 6
2 5 8 9
3 1 6 7
4 5 9 8
5 5 9 9


Any help is greatly appreciated!

Thanks,

Dom

Maybe

=SUMPRODUCT((A1:A5=5)*(B1:B5<C1:C5))

VBA Noob