Smart questions
Smart answers
Smart people
Join Eng-Tips Forums
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

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

Join Eng-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

waterguy (Civil/Environmental) (OP)
3 Jul 01 11:36

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.
linqur (Mechanical)
3 Jul 01 12:36
Hi watergui,
Paste this in A1 =IF(ISBLANK(B1);"Empty";"Something")
and change values in B1.
Hope it helps
Linqur
waterguy (Civil/Environmental) (OP)
3 Jul 01 13:58
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 !

linqur (Mechanical)
3 Jul 01 14:22
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

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!

Back To Forum

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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close