Lookups and References in relations to countA or 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

Biff

Hi!

Try this:

A1 = 331

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

Biff
 

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

Countif With Criteria 1
Lookup or an alternative 2
Lookups and references in relation to countA, sumproducts 2
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
Any body out there smart enough??? 9

Top