Using OFFSET and/or COUNTA within SUMPRODUCT Function

Is it possible to use an OFFSET and/or COUNTA formula within a SUMPRODUCT formula? I am using a SUMPRODUCT formula, which is using rows 13-33. I want the array to always start in row 13 but the last row is always changing (i.e. today the last row of data is row 33 but next week the last row might be row 1000. Can I build something into the formula to account for this? I've attached a sample of how the data is layed out (current formula is in D2:D6).

=SUMPRODUCT(--($D$13:$D33=C2),--($E$13:$E33="Yes"))