Trying to do conditional counting, units within units

I have this formula,

Formula:

{=IF($A82="Sessions",SUM(IF(C$73="",1,Day_Data[[Macrocycle]:[Macrocycle]]=C$73)*IF(C$74="",1,Day_Data[[Mesocycle]:[Mesocycle]]=C$74)*IF(C$75="",1,Day_Data[[Microcycle]:[Microcycle]]=C$75)*IF(C$76="",1,Day_Data[[Session]:[Session]]=C$76)))}

which will count the number of sessions per session, microcycle, mesocycle and macrocycle.


I thought if I shortened it to this,

Formula:

{=IF(AND($A83="Microcycles",COUNTA(C$73:C$76)<=3),SUM(IF(C$73="",1,Day_Data[[Macrocycle]:[Macrocycle]]=C$73)*IF(C$74="",1,Day_Data[[Mesocycle]:[Mesocycle]]=C$74)*IF(C$75="",1,Day_Data[[Microcycle]:[Microcycle]]=C$75)))}

it would count the number of microcycles per microcycle, mesocycle and macrocycle. However, looking at formula results that isn't happening.


What formula needs to exist in rows 83 and 84 to return accurate counts? I am aware counting number of sessions per session, microcycles per microcycle, etc. is silly but I didn't want a false returned in that situation.