conditional formula

[Anthony]

Hi

I am looking for a conditional formula, please attached document.

The YTD sheet is referencing data from the Quarter sheet, the Quarter
sheet is referencing data from the Monthly, if any sheet's value is 0 I do
not want that sheet referenced in the results, Is there a formula for this?

 

[Carl Witthoft]

Hi

I am looking for a conditional formula, please attached document.

The YTD sheet is referencing data from the Quarter sheet, the Quarter
sheet is referencing data from the Monthly, if any sheet's value is 0 I do
not want that sheet referenced in the results, Is there a formula for this?

Do you mean if a cell on a referenced sheet is zero, or any cell at all?

Or just

IF(Quarter![cellreference] = 0, 0, {some formula using that
cellreference} )

Is that what you're looking for?

 

[Anthony]

Carl-

I am developing a monthly score card rolling over into a quarterly, and then
into an anual average card. If any sheet is blank monthly or quarterly I do
not want it referenced in the average. I this makes sense to you :0)...thanks

AP

Hi

I am looking for a conditional formula, please attached document.

The YTD sheet is referencing data from the Quarter sheet, the Quarter
sheet is referencing data from the Monthly, if any sheet's value is 0 I do
not want that sheet referenced in the results, Is there a formula for this?

Do you mean if a cell on a referenced sheet is zero, or any cell at all?

Or just

IF(Quarter![cellreference] = 0, 0, {some formula using that
cellreference} )

Is that what you're looking for?

 

[Carl Witthoft]

Ok,
sounds like you need to play with the SUMIF and COUNTIF functions.
Check out the help page for details, but basically you should be able to
get a count of the numbe of non-blanks, and use that to generate the
stats you want.

Carl-

I am developing a monthly score card rolling over into a quarterly, and then
into an anual average card. If any sheet is blank monthly or quarterly I do
not want it referenced in the average. I this makes sense to you :0)...thanks

AP

Hi

I am looking for a conditional formula, please attached document.

The YTD sheet is referencing data from the Quarter sheet, the Quarter
sheet is referencing data from the Monthly, if any sheet's value is 0 I
do
not want that sheet referenced in the results, Is there a formula for
this?

Do you mean if a cell on a referenced sheet is zero, or any cell at all?

Or just

IF(Quarter![cellreference] = 0, 0, {some formula using that
cellreference} )

Is that what you're looking for?