CountIf on Text in cells if used not more than once, then sum the results.

Count if:

I am trying to count values in Column A where if the values are used more than once, (i.e. Billy A), the total desired result should be in cell g1, where total count in of all values in column a, which are not used more than once. So total count should be 3, as in cell g1, where it is counting the values in column a, which were not used more than once.

Then using values in Column B, these should only sumif, the values in column A, which were not counted more than once, so in this case, it should only add up, cells b3..b5, because these were the values in column a, not counted.

Desired result in columns g1 and g2.


Thanks in Advance.

Thanks daddylonglegs & bebo021999 both solutions worked. Appreciate your help


Trying to understand...


daddylonglegs..why add the + 0?

Bebo...
what does -- mean when using sumproduct?

I tried without the -- in the 2nd formula you gave and it still worked, when removing the -- in first formula it made it 0. so trying to understand...

Thanks daddylonglegs. That is starting to make sense...