software

The following formula counts the number of non blank cels in row e,
and totals the number of cels that are non blank on the summary
page:
{=sumif((dress! a:a = a1)*(dress!e:e lt;gt;=),1))}

I also want to NOT add any cell that has a duplicate reference
number
in column c.dress sheet

abcde
deptcolorstylenameunits
331blk112
331blk212
331blk212
332blk412
332blk512
332blk612
332blk612
332blk712cel a1 on sheet 2(summary sheet) is 331, so the answer should be 2
Because style 2 in dept 331 is listed twice.

I assume I have to add to my existing formula?--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: www.excelforum.com/member.php...oamp;userid=31587
View this thread: www.excelforum.com/showthread...hreadid=513376