dcd123 wrote...
I need the cell references to remain as they are, row, column, and
block. Is there another function that will accommodate this?

Here's your formula.

=SUMPRODUCT(ISNUMBER(SEARCH(" - D",'Discussed vs Opened'!A1:AS1))
*('Discussed vs Opened'!C2:C1512=Summary!A3)
*('Discussed vs Opened'!E2:AS1512="Yes"))

On their own, none of the criteria present a problem. Also, pairing the
middle criteria with either of the other two presents no problem.
However, the pairing the first and third criteria NECESSARILY results
in an error because the two ranges have different numbers of multiple
columns. Excel can't handle A1:S1 * E2:AS1512. It doesn't make sense.
What would the extra columns in the former correspond to in the latter?

There may be a way to do what you want, but you're going to have to
explain it IN PROSE, not with formulas.