I am puzzled on how to write a sum formula for the following
(from a very large entry form that somebody else designed with data validation
which only allows "X") in the size column.

A B C D E F
Red Navy Pewter Small Medium Large
2 X

How do i get a total of small red shirts from a formula ?

Steve