Biff wrote:

....

=SUMPRODUCT(--(D3:D28="M")+(D3:D28="F"))

-- is redundant, because the addition coerces both logical arrays to
numbers.

Jerry