Lookups and references in relation to countA, sumproducts

J

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?
 
B

Bob Phillips

See responses in excel.misc

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookups and References in relations to countA or sumproducts 1
Lookups and References in relations to countA and sum products.... 5
Sumproducts, Counta Lookup Ref Formulas 7
countif counta with multiple lookup criteria 1
Countif With Critiera 4
Countif With Criteria 1
Any body out there smart enough??? 9
Array Formula With Multiple Conditions 3

Top