Also Cast

Count: as the name itself explains, it counts all the values in a column

Count DISTINCT in the other hand doesn't count the duplicate sets of data

=SumProduct => gets the sum of 2 arrays multiplied together