Count in a certain date

[natisham]

Hello,

Im trying to count Engine hours over 40 hours by week. So I just need it to read

Header 1	Header 2
Engine Hours over 40	7
Engine Hours under 2	5

It would count Machine Names with over 40 Engine hours per week.

Currently I have :

Count({$<[Engine on (h)]={"<2"}>}[Engine on (h)])       but it is giving me the total and not counting the number of weeks it ran under 2 hours.

Please help.

[sunny_talwar]

So then it appears that the if statement is working for you, isn't it? Are you looking to use set analysis to improve performance?

[natisham]

Yes please , For every cell that is over 40 hours i need to count it as 1. Then  add them all together for the month.