Count Unique instances across several Columns

Hi

I've come up with the attached which includes this array formula -

=SUM((C2:C50=$J$2)*(H2:H50=$K$2)*(D2:D50=$L$2)*(F2:F50=M2))

So enter with Ctrl-Shift-Ent

It requires a helper column for the month number and requires you to input month number.
Updated with improved s/s to show all permutations

Hi Welcome to the forum.

A SUMPRODUCT, version..

Start date =J1

End date =J2

For all "111"

=SUMPRODUCT(($C$2:$C$53=111)*($E$2:$E$53>=$J$1)*($E$2:$E$53<=$J$2))

For Day

=SUMPRODUCT((($C$2:$C$53=111)*($F$2:$F$53="Day")*($E$2:$E$53>=$J$1)*($E$2:$E$53<=$J$2)))

For night

=SUMPRODUCT((($C$2:$C$53=111)*($F$2:$F$53="Night")*($E$2:$E$53>=$J$1)*($E$2:$E$53<=$J$2)))

Is this, works for you?

see if this helps. with this, you could find HOURS for just 111, or 111 + Day shift, or just DAY shift, or 111 + April... try it out.

you have some white spaces in your data, which scupper calculations.

Try this, with CTRL+SHIFT+ENTER, rather than just ENTER

=SUM(IF(FREQUENCY(IF(C$2:C$53=Equip,IF((E$2:E$53>=StartDate)*(E$2:E$53<=EndDate),IF(F$2:F$53<>"",MATCH(E$2:E$53&"|"&F$2:F$53,E$2:E$53&"|"&F$2:F$53,0)))),ROW(F$2:F$53)-ROW(F$2)+1),1))

Of Course should have more intellectual ways.

Change the Equipment, Start & End Dates.