In article ,
KenB wrote:

How do I sum values for a column where column 1 matches column 2 cells. The
sum value is in column 3. Example:
col1 col2 col3
9B 9b 15
AA BB 7
dd dd 9
24 Total sum where values are =.

Try...

=SUMPRODUCT(--(A1:A3=B1:B3),C1:C3)

Also, do the same totals on another sheet without repeating col1. In other
words sheet2 has only cols 2 & col3. I am sure this is simple. But I am new
to Excel.

Can you elaborate?