Concatenation and the SUMIF Function in Microsoft Excel Nicola 2 years ago Microsoft Excel Tips and Tricks In this Introduction to Data Analysis with Excel training, we show you how to use the CONCAT and SUMIF Functions in Microsoft Excel. Credit Simon Sez IT