Countif With Criteria

  • Thread starter Thread starter JR573PUTT
  • Start date Start date
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?
 
Good grief! Look at the replies you've already had in all the other groups
you've posted to.
 

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
countif counta with multiple lookup criteria 1
Countif With Critiera 4
Lookups and References in relations to countA and sum products.... 5
Lookups and references in relation to countA, sumproducts 2
Any body out there smart enough??? 9
Sumproducts, Counta Lookup Ref Formulas 7
Lookup or an alternative 2

Back
Top