Hi,

I have been battling with this for a while now, there must be a relatively simple way of doing it, seems like an obvious thing that one might want to do in excel.

Imaging you have a number of different values in column 'A' going down to say, line 100.

We then also have a number of values in column 'B' also going down to line 100. The values in columns 'A' & 'B' are different.

I want to create a formular in the cell at the bottom which states how many cells in column B are greater than the adjacent cell in column A. Due to the layout of the sheet I want to acheive this without having to create an extra column. I would also prefer to avoid using a huge chain of the COUNTIF funtion for each line seperately.

I have heard that this may be acheivable using the SUMPRODUCT function, although so far I have not been able to figure out how. I also suspect it could be acheived by writting a custom function in VBA that will use the COUNTIF comand but inside a loop. Again I have not worked out exactly how to do it.

Can anyone suggest a solution for me here please?

Hopefully I have explained my intentions clearly, if not please advise and I will elaborate further.

Many thanks