Count cell only if date matches current month & year

Originally Posted by Ace_XL

Try

=SUMPRODUCT(--(TEXT(A2:A10,"mmyyyy")=TEXT(TODAY(),"mmyyyy")))

This worked perfectly, thanks!

As a related question, how would I then only count that set of data IF another cell has a certain value? (ex: column A matches this month and year, AND column B is "Name")

Thanks again!