Countif match specific day

the data:

9/1 9/2 9/3 9/4 ~> 9/30

group b x x x x x

group b x x x x x

group a x y x x y     

group c x y y y y

group c x y y y y

group b x x x x x

group c x y y y y

 

I need a formula that can count the number of y on a specific day for that specified group.

 

so in a report sheet i have the formula =now() or =today() and I would it to return # of y for that day for those groups.

By: madeinshanghai

One thought on “Countif match specific day

Leave a Reply

Your email address will not be published. Required fields are marked *