Hi,

I have two columns that each have numbers and blank cells - column H and column I - and x number of rows. I currently have the array formula (included in another sheet) below to count how many numbers in the first column (column H) are greater than the corresponding numbers in the second column (column I). An example of a result of this formula is that there are 60 instances where the number in column H is greater than the corresponding number in column I.
The only problem is that this array formula also counts the blanks/zero values.

{=(SUM((Sheet1!$I17:$I451<Sheet1!$H17:$H451)*1))}

How may I alter this formula so that it counts the number of numbers in column H that are greater than the numbers in column I, ignoring all blanks? I am using Excel 2010.
(Apologies, I'm very new to array formulas, and endless research online hasn't helped.)

Thanks in advance for your help!

RN