display range of values

W

willemeulen

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
 
P

Pecoflyer

willemeulen;332136 said:
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
Click to expand...

Hi,
for your last question have a go at the SUMPRODUCT function.
It is very nicely explained at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html#classic

HTH
 
Top