If 0's exist in column

[shayb]

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.

 

[shayb]

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]

Try this:

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

 

[shayb]

Worked Great! Thanks!