Countifs on multiple columns & criteria

Need to calculate occurrence of cells with zero value, over day & hour. Also need to find occurrence of values which are greater than zero.

Data are values in minute by minute and over 30 dates period, if needed hour formula column can be added if minutes cannot be converted into hour.

have attached file with expected result.

Thanks

Enter this in B2 for 0 values:

Formula:

Please Login or Register  to view this content.

Enter this for >0 values:

Formula:

Please Login or Register  to view this content.

But first in hours (A column) add 24 (after 23) to get whole day.

Many thanks...

formula u posted has now able to calculate the desired result...

your suggestion regarding for calculating hour 23, i have modified & add >A2 specifically in 23 hour.

=SUMPRODUCT((data!$B$1:$AD$1=B$1)*(data!$A$3:$A$1442>=$A25/24)*(data!$A$3:$A$1442>$A2/24)*(data!$B$3:$AD$1442=0))

That way you have one formula different than other so you lose consistency.
You can do that but I would rather fix input table.
You can hide that row or format font with white number.
It doesn't need to be visible.
It's just there for calculation.

But yes, your formula will work too.