Need help with a formula

[pujo]

Morning!

FOQD = a range of dates.
FOURTH_QUARTER = a range of number for the fourth quarter.

The formula is displaying the first date in the range however the data for this date is zero. Being that the fourth quarter doesn't have any data yet. (works right with data)
How can I make the formula return a zero or blank if the FOURTH_QUARTER range is all zero's?

=IFERROR(INDEX(FOQD,0,MATCH(MAX(FOURTH_QUARTER),FOURTH_QUARTER,0)),"0")

Thanks all!
(hope I explained it right)

 

[Marcelo Branco]

Maybe...

=IF(COUNTIF(FOURTH_QUARTER,">0"),INDEX(FOQD,0,MATCH(MAX(FOURTH_QUARTER),FOURTH_QUARTER,0)),"")

M.

 

[pujo]

Marcelo, the formula works like I want. Thanks!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.