×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Empty Cells and "IF" statements

## Empty Cells and "IF" statements

(OP)

I have a columm of data and need to calculate the sum of every seven (7) values.  For Example, the sum of values 1 thru 7 (inclusive), then the sum of values 2 thru 8, then 3 thru 9, etc....

This is simple enough, but the problem is that the data is incomplete, and prior to summing the values I want to perform a check to ensure that there are no empty cells (ie. no data) within the set of numbers that I want to sum.  If a cell(s) are empty I will indicate that the data is incomplete and not perform the sum for that set, otherwise, I will perform the sum.

Is it possible to check values in a Range using an IF statement ?  Or to check for for an empty cell within a range using an IF statement ?

I have used VBA code in the past, and was anticipating doing it for this, but I thought I would pose the question to see what others thought, or if there is an easier way to do it.

Thanks.

### RE: Empty Cells and "IF" statements

Hi watergui,
Paste this in A1 =IF(ISBLANK(B1);"Empty";"Something")
and change values in B1.
Hope it helps
Linqur

### RE: Empty Cells and "IF" statements

(OP)
Thanks for the response Linqur.

I did some more digging and figured out a way to do it using a COUNTBLANK statement nested inside an IF.  See below:

=IF((COUNTBLANK(A1:A7)>0),"INCOMPLETE",(SUM(A1:A7)))

It seems that half the battle with Excel is getting to know all the functions that are available !

### RE: Empty Cells and "IF" statements

Yes right
you wanted to check 7 cells for incompletes.

Help system is quite useful once you've
spent enough time reading it and have gathered
bookmarks in you mind "I saw once something about that somewhere".

Linqur

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!