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 use EXACT alone or with the IF function (in case you want to get a descriptive result...
To check a condition, we have to use a logical operation that only results in Boolean values (TRUE or FALSE). But multiplying TRUE or FALSE with the sum_range will only result in 0s. So, to convert those boolean values into usable 1s (TRUE) and 0s (FALSE), we need to enclose the...