SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
COUNTA does not count empty cells.
Multiple cells have same value case sensitive
To verify that multiple cells have the same value with a case-sensitive formula, you can use a simple array formula based on the EXACT function with the AND function. In the example shown, the formula in G5 is: =AND(EXACT(B5:F5,B5)) This is an array formula and must be entered with control + shift + enter
