The above formulas ignore cases when comparing text values. If you want to make the comparison case-sensitive, you need to use the EXACT function. The Excel EXACT function is used to compare two text strings and returns TRUE if both values are the same, and FALSE otherwise. You can either...
=SUMPRODUCT(array1, [array2], [array3],...) Arguments: array1(required) – This is the first array or range of cells whose values you want to multiply and then add. [array2], [array3],…(optional) – This is the second (and third) array or range of cells whose values you want...