Hi,
I have data in columns A and B and would like to create an array formula to count the number of instances when the value in a particular cell in A is larger than the value in the adjacent cell in column B.
I tried {=countif(A1:A1000-B1-B1000,">0")} which doesn't work.
Can someone please suggest a solution. I need the formula to work in Excel 2003
Thanks!
Bookmarks