software

I have 2 sheets, one summary, and one detail.

The detail is as follows:Dept units
331 12
331 24
331
331 12
332
332 36
332 24
333

The summary is as follows:Dept # of styles
331 3
332 2
333 0

I want the formula on the summary sheet to count the number of non
blank entries for each dept.

Which formula is it?--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: www.excelforum.com/member.php...oamp;userid=31587
View this thread: www.excelforum.com/showthread...hreadid=512836Hi!

Try this:

A1 = 331

=SUMPRODUCT(--(Details!A$1:A$100=A1),--(Details!B$1:B$100lt;gt;quot;quot;))

Biff

quot;JR573PUTTquot; gt; wrote
in message ...
gt;
gt; I have 2 sheets, one summary, and one detail.
gt;
gt; The detail is as follows:
gt;
gt;
gt; Dept units
gt; 331 12
gt; 331 24
gt; 331
gt; 331 12
gt; 332
gt; 332 36
gt; 332 24
gt; 333
gt;
gt; The summary is as follows:
gt;
gt;
gt; Dept # of styles
gt; 331 3
gt; 332 2
gt; 333 0
gt;
gt; I want the formula on the summary sheet to count the number of non
gt; blank entries for each dept.
gt;
gt; Which formula is it?
gt;
gt;
gt; --
gt; JR573PUTT
gt; ------------------------------------------------------------------------
gt; JR573PUTT's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31587
gt; View this thread: www.excelforum.com/showthread...hreadid=512836
gt;