If 0's exist in column

shayb

Board Regular
Joined
Apr 21, 2004
Messages
81
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.
 

Some videos you may like

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
Joined
Apr 21, 2004
Messages
81
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
Joined
May 19, 2002
Messages
8,458
Try this:

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

Watch MrExcel Video

Forum statistics

Threads
1,119,142
Messages
5,576,318
Members
412,716
Latest member
thviid
Top