As per title,
looking for a shortcut or alternative to type;
=SUM(COUNTIF(H2:H200{"A","B","C","D","E"}))
where A,B,C,D,E.....Z are several long text statements that I have listed, it would take a great deal of time to copy and paste then add quote marks and commas...
Thanks in advance
Bookmarks