Any body out there smart enough???

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

 

[jhct]

try COUNT

 

[JR573PUTT]

CountA is only part of the formla??????

 

[gjcase]

Use Dcount. Excel Help explains pretty well how to use it.

---Glenn

 

[JR573PUTT]

Dcount Did Not Wor

 

[Bob Phillips]

=SUM(IF((A1:A10=331)*(B1:B10<>""),1))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Doug Kanter]

CountA is only part of the formla??????

Maybe he thought you were SMART ENOUGH to use the Insert Formula menu
command, and notice that it offers rather clear help for how to use whatever
formula you choose from the pick list that's right in front of you. Maybe.

 

[JR573PUTT]

Sorry good one, but suffice to say I be smart enough to do that, but th
formula want work, are you smart enough to write down the right formula

 

[Doug Kanter]

Sorry good one, but suffice to say I be smart enough to do that, but the
formula want work, are you smart enough to write down the right formula?

I already have too many apps running, none of which can be shut down at the
moment. If I start Excel, the whole house of cards will fall. So, use
Insert, Formula, choose the formula or function you want to use, and the
next dialog box (if I recall) will show you very clearly how to use the
formula. If not, the Excel help system may contain further illustrations.

 

[pinmaster]

Another way:

=SUMPRODUCT(('detail sheet'!$A$1:$A$10=331)*('detail
sheet'!$B$1:$B$10<>""))



HTH

Jean-Guy