[Solved] Formulas: Compare two data columns ignoring blanks

[Greg]

Hi everyone,

I have two columns A and B where a value in A must be less or equal than a corresponding entry in B.

Using the following formula to check for errors:
=sumproduct((A4:A11>B4:B11)*1)

However, there might be blanks in B but value in A. I don't want to count these occurences.
How can I achieve that?

Thank you,
Greg

[Derk]

Try
=SUMPRODUCT((A4:A11>B4:B11)*(NOT(ISBLANK(B4:B11))))

[Greg]

Great, this is it.

Thank you, Derk