Lookups and References in relations to countA or sumproducts

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?

Hi!

Try this:

A1 = 331

=SUMPRODUCT(--(Details!A$1:A$100=A1),--(Details!B$1:B$100<>""))

Biff

"JR573PUTT" <JR573PUTT.23aa8o_1140028803.4945@excelforum-nospam.com> wrote
in message news:JR573PUTT.23aa8o_1140028803.4945@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=512836
>