Hi,

I have four columns, L2 M2 V2 W2.

I'm trying to make it so it adds up the amount of times a value in L is larger then the value in M for the whole column, but also only counting when the value in V is larger then W, also for the whole column.

Can anybody work out the formula for me?

I have "=MAX(L2:L14654,M2:M14654)" and "(=MAX(V2:W14654,V2:W14654)"

But these only work out the largest value in the whole column.

Any help is appreciated.