display range of values
 

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

display range of values
 

willemeulen;332136 Wrote:
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

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

HTH


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=92833