Hi, I have a formula, that I feel like should be shorter:

=COUNTIFS(INDIRECT("Data!B2:B100000"),">"&EndLastYear,INDIRECT("Data!B2:B100000"),"<="&ThisMonth,INDIRECT("Data!J2:J100000"),"Value A")+COUNTIFS(INDIRECT("Data!B2:B100000"),">"&EndLastYear,INDIRECT("Data!B2:B100000"),"<="&ThisMonth,INDIRECT("Data!J2:J100000"),"Value B")+COUNTIFS(INDIRECT("Data!B2:B100000"),">"&EndLastYear,INDIRECT("Data!B2:B100000"),"<="&ThisMonth,INDIRECT("Data!J2:J100000"),"Value B")

I was trying to use a sumproduct, somewhere, but couldn't seem to figure it out. Any help would be awesome! (Also, would there be a way to have a named range for the list of "Values"?)