Excel Question - TechRepublic
General discussion
October 14, 2005 at 01:18 PM
johnshenyang

Excel Question

by johnshenyang . Updated 20 years, 8 months ago

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.

This discussion is locked

All Comments