countif counta with multiple lookup criteria

J

JR573PUTT

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?
 

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

Sumproducts, Counta Lookup Ref Formulas 7
Countif With Critiera 4
Any body out there smart enough??? 9
Array Formula With Multiple Conditions 3
array formula with duplicates 0
Array Formula Sum If With Duplicate 18
Array formula with 2 conditions... 0
Lookups and References in relations to countA or sumproducts 1

Top