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
Bookmarks