Is there a way to add another variable in this statement?

Column L is the value to add, Column A is where the data is that matches CV$2. I have another column that has "YES" and blanks so I only want to sum those items that say "YES". Is that possible?


=SUMPRODUCT(SUBTOTAL(9,OFFSET('Billings Data'!$L$2,ROW('Billings Data'!$L:$L)-ROW('Billings Data'!$L$2),0)),('Billings Data'!$A:$A=CV$2)+0)