Concatenate Add another column then use "concatenate" on the original two columns. The positive result will show TN in the new column, then do your "sumif" on the new column looking for TN.
Undo A Windows thing but (very) well used in Excel - the curly arrow pointing left on the standard toolbar which undoes your last action - often used to undo wrongly made changes before they do any harm.
My answers
Concatenate
Add another column then use "concatenate" on the original two columns. The positive result will show TN in the new column, then do your "sumif" on the new column looking for TN.
Undo
A Windows thing but (very) well used in Excel - the curly arrow pointing left on the standard toolbar which undoes your last action - often used to undo wrongly made changes before they do any harm.