On the bottom of the sheet I show a summary from the sheet itself. How do I
automatically display all unique values listed from certain column.

In second column the SUMIF function will give total of the unique value.

PS is it possible to do sumif for two if's (colum a must be value @ and
column B must be #)?

Thanks