Software

Ask something
Discussion Locked

Excel Formula Question

0 helpful
1 reply

by johnshenyang

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

1 reply

by delfeye

Here is the formula for the spcific range you specified;

=IF(COUNTBLANK(B2:E2)>0,"BLANK CELL FOUND",SUM(B2:E2))

Can't get more explicit than that.

This discussion is closed to new replies.