質問がありましたので・・・
Excelの計算結果でゼロの場合の表示をオン・オフする設定を整理しました。
ダミーデータです。C21:H25のセルの計算式は以下の通りです。
C21 =COUNTIF(C$4:C$15,">=5000")
-COUNTIF(C$4:C$15,">=10000")
C22 =COUNTIF(C$4:C$15,">=10000")
-COUNTIF(C$4:C$15,">=20000")
C23 =COUNTIF(C$4:C$15,">=20000")
-COUNTIF(C$4:C$15,">=30000")
C24 =COUNTIF(C$4:C$15,">=30000")
-COUNTIF(C$4:C$15,">=40000")
C25 =COUNTIF(C$4:C$15,">=40000")
-COUNTIF(C$4:C$15,">=50000")