Count Number of Cells in Column B if Cells in Column A are less?

[razzandy]

Hi Guys

Driving me mad this

Lets say we have a list of numbers in Columns BD and Column BE as below and I want to count how many of the cells in Column BE are greater then the adjacent Cells in Column BD? I have tried Countif and Countifs (=COUNTIF(BE:BE,">"&BD2)) but it counts anything in the column which is above that particular cell i.e cell BE2 or BE3 and so on. I can do a simple =IF(BE2>BD2,1,"") in one Column to return 1's then =COUNT(BJ:BJ) to count the 1's but its just so long winded and I want to be able to use it in VBA with Application.WorksheetFunction.CountIf(). I was really hoping Countif would have worked but I think I have a mental block due to working on it for so long!

Thanks in advance and have a great weekend!

 

[razzandy]

I rarely use Worksheetfunction in VBA, so not sure why code doesn't work.

No Fluff, I think you have misunderstood me. Your Code is working and implemented into my code so thanks again.

 

[Fluff]

You're welcome & thanks for the feedback.