# If 0's exist in column

#### shayb

##### Board Regular
I have a column and it is listed by Month from Jan 04 - Dec 05. Every 3 months is a "Quarter". For example A1-A3 will be Jan 05 - Mar 05 or Qtr. 1. and so on. Some months have sales (\$) and some months have 0 Sales or (\$0.00). I have another column listed as below:

Qtr 1 - 04
Qtr 2 - 04
Qtr 3 - 04

...and so on

Now, in the third colum, I am summing up the first three months beside Qtr 1 - 04 and then I sum up the next set of 3 months for Qtr 2 - 04 and so on. I want to add a 4th column and specify whether each Qtr. or 3 month period has sales in each month. Basically, if any month during the quarter has \$0.00 for sales, I want that quarter to say "Incomplete". Any ideas? Thanks.

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

#### shayb

##### Board Regular
Let's see if I can make this more simple

Okay, let's say you have 3 cells:
A1 is Jan 05
A2 is Feb 05 and
A3 is Mar 05

Now in column B there are sales figures for each month. If one of the months has \$0.00 or less sales, then I want to put "Incomplete Quarter" in a 3rd column. Is this easier to follow? Sorry for the complicated original post.

#### texasalynn

##### Well-known Member
Try this:

=IF(OR(H61=0,I61=0,J61=0),"Incomplete",SUMIF(H61:J61,"<>0"))

#### shayb

##### Board Regular
Worked Great! Thanks!

Replies
1
Views
180
Replies
29
Views
1K
Replies
9
Views
286
Replies
2
Views
392
Replies
5
Views
286