=SUM(IF((A1:A10=331)*(B1:B10<>""),1))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"JR573PUTT" <JR573PUTT.23a9ry_1140028201.3161@excelforum-nospam.com> wrote
in message news:JR573PUTT.23a9ry_1140028201.3161@excelforum-nospam.com...
>
> 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=512827
>