The SUMIF function can be used to change the contents of the total according to conditions, and the SUMIFS function can be used to specify multiple conditions. The reason why and how to use the SUMIF...

Struggling to extract text after a specific character in Excel when data lengths vary? This article explains how to combine the RIGHT and FIND functions to solve the problem—taught by an experienced Excel formula expert.