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.
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.