Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named range not continuous. How to display values? | Excel Worksheet Functions | |||
some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
Excel 2007 Display value based on values in another column range | Excel Worksheet Functions | |||
Display values set in a range?? | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |