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