Hi!
Try this:
A1 = 331
=SUMPRODUCT(--(Details!A$1:A$100=A1),--(Details!B$1:B$100<""))
Biff
"JR573PUTT" wrote
in message ...
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:
http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=512836