Lookups and References in relations to countA and sum products....

[JR573PUTT]

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?

 

[Bob Phillips]

See responses excel.misc

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Trevor Shuttleworth]

You've asked the same question five times in four different groups in the
apace of about five minutes. The same people look at most of the groups so
please don't waste everyone's time and effort.

See my response to your question in one of the other groups; I'll leave you
to find it. Let's waste a bit of your time

Regards

Trevor

 

[JR573PUTT]

Trevor,

If you don't know the answer, don't respond, that way you are not
wasting your time or MY TIME, your formula want work..............

 

[Trevor Shuttleworth]

You are such a prat. If you took the time and trouble to look at the other
posts you'd find that I have already answered it.

 

[Bernard Liengme]

Do you mean "will not" or "won't" work?