=SUMPRODUCT(--(Events!$A:$A="X"),--(Events!$T:$T+Events!$V:$V>=1),--(Events!$T:$T+Events!$V:$V<=64))
=SUMPRODUCT(--(Events!$A:$A="X"),--(Events!$T:$T+Events!$V:$V>=65),--(Events!$T:$T+Events!$V:$V<=96))
=SUMPRODUCT(--(Events!$A:$A="X"),--(Events!$T:$T+Events!$V:$V>=97),--(Events!$T:$T+Events!$V:$V<=192))
=SUMPRODUCT(--(Events!$A:$A="X"),--(Events!$T:$T+Events!$V:$V>=1),--(Events!$T:$T+Events!$V:$V<=64))
=SUMPRODUCT(--(Events!$A:$A="X"),--((Events!$T:$T+Events!$V:$V>=193)*INT((Events!$T:$T+Events!$V:$V+384)/576)))
Bookmarks