Shortening the Countifs formula.

[countryfan_nt]

Hello friends, Hope all is well!

Is there a shorter version to make the below formula?

it suppose to give a 1, if any result showed up in a certain month, and provided that the amount related is above 4999.

1. Basically, the point is to show the number of months that had any activity or results above 4999.
2. The formula is too long, can it be shortened?

=SUM(IF(COUNTIFS($B$4:$B$13,{"Jan"},$C$4:$C$13,">4999")>0,1,0)+IF(COUNTIFS($B$4:$B$13,{"Feb"},$C$4:$C$13,">4999")>0,1,0)+IF(COUNTIFS($B$4:$B$13,{"Mar"},$C$4:$C$13,">4999")>0,1,0)+IF(COUNTIFS($B$4:$B$13,{"Apr"},$C$4:$C$13,">4999")>0,1,0)+IF(COUNTIFS($B$4:$B$13,{"May"},$C$4:$C$13,">4999")>0,1,0)*IF(COUNTIFS($B$4:$B$13,{"Jun"},$C$4:$C$13,">4999")>0,1,0)+IF(COUNTIFS($B$4:$B$13,{"Jul"},$C$4:$C$13,">4999")>0,1,0)*IF(COUNTIFS($B$4:$B$13,{"Aug"},$C$4:$C$13,">4999")>0,1,0)+IF(COUNTIFS($B$4:$B$13,{"Sep"},$C$4:$C$13,">4999")>0,1,0)+IF(COUNTIFS($B$4:$B$13,{"Oct"},$C$4:$C$13,">4999")>0,1,0))

Thank you very much in advance!

 

[oldbrewer]

					jan	feb	mar	apr	may	jun	july	aug	sep	oct	nov	dec
						1000		5200	4500	4200	6666			3	4	5
						2
						=SUMPRODUCT(($F$8:$Q$8>4999)*1)

<colgroup><col width="64" span="18" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

col F

jan

feb

mar

apr

may

jun

july

aug

sep

oct

nov

dec

row 8

1000

5200

4500

4200

6666

3

4

5

2

=SUMPRODUCT(($F$8:$Q$8>4999)*1)

<colgroup><col width="64" span="19" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

Try:

=SUM(COUNTIFS($B$4:$B$13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct"},$C$4:$C$13,">4999"))