Counting Defines

[asyamonique]

Hello
Good Day,
There are numbered staff check in times at the column M3:M12 like 6,8,10,12,14,16,18,20,22,24
I did defined them into three categories as day, swing and graveyard (day:M3:M6 swing:M7:M9 graveyard: M10:M12 )
Column D has that numbers as in scheduled all the way down.
I've just tried below formula to find out the results but it didn't worked..
Is there any way that I can add in that formula to count easy way those three defined categories?
Many Thanks

=COUNTIF(D:D,"day")

 

[BSALV]

probably with a spillformula, but be aware, D:D, that are +1.000.000 rows !!!
After a while, your spreadsheet 'll slow down.

=SUMPRODUCT(--ISNUMBER(MATCH($D$1:$D$100,day,0)))

 

[asyamonique]

Thanks