Announcement

Collapse
No announcement yet.

[Solved] Formulas: Compare two data columns ignoring blanks

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Solved] Formulas: Compare two data columns ignoring blanks

    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

  • #2
    Try
    =SUMPRODUCT((A4:A11>B4:B11)*(NOT(ISBLANK(B4:B11))))
    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

    Comment


    • #3
      Great, this is it.

      Thank you, Derk

      Comment

      Working...
      X