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
Paste this in A1 =IF(ISBLANK(B1);"Empty";"Something")
and change values in B1.
Hope it helps
Linqur
RE: Empty Cells and "IF" statements
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
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