Excel Hack 57: Count all cells in a range that start with the same prefix…
(…or end with the same suffix..!) This is another quick tutorial on one of the many applications of the =SUMPRODUCT function. Sometimes you are working with a dataset and you are looking out in particular for a starting 4-number code, or 3-letter prefix, or GL codes that start with the same 2 numbers. The following