Empty Cells and "IF" statements

[waterguy]

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]

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

 

[waterguy]

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]

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