Count if w/ 2 criteria

I'd like a count of number of entries, if an entry's date in column L matches the date in Cell A2, and the name in column G matches the name in Cell C1.

I'm entering the formula as below:

=COUNTIFS($L$27:$L5000,"=$C$1",$G$27:$G$5000,"=$A2")

I'm getting #Value!

Any advice on where I'm going wrong would be greatly appreciated.

=sumproduct(--($l$27:$l5000=$c$1),--($g$27:$g$5000=$a2))