General discussion

  • Creator
    Topic
  • #2189134

    Excel Question

    Locked

    by johnshenyang ·

    Hi —
    If I want to sum a row of numbers ONLY IF there are NO blank cells in the row (and if there are any blank cells then the cell where the sum would appear would instead return a message like “BLANK CELL FOUND”, then how do I do this? Please be explicit, I am a beginner :). (The range I want to sum/check for blanks is B2:E2.
    Thnx,
    j.

All Comments

  • Author
    Replies
    • #3119237

      Reply To: Excel Question

      by mj_consult ·

      In reply to Excel Question

      You’ve probably solved this one or found a work around by now. But just in case you still need an answer, here is one.
      In your answer cell try this If function:
      =IF(ISBLANK(range),”Blank Cell Found”,SUM(range))
      Range may be either B2:E2 or you may name the range and insert the name here.

Viewing 0 reply threads