Any body out there smart enough???

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?

try COUNTA

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

"JR573PUTT" <JR573PUTT.23aa8n_1140028801.5666@excelforum-nospam.com> wrote
in message news:JR573PUTT.23aa8n_1140028801.5666@excelforum-nospam.com...
>
> 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.

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?

"JR573PUTT" <JR573PUTT.23abmq_1140030603.9411@excelforum-nospam.com> wrote
in message news:JR573PUTT.23abmq_1140030603.9411@excelforum-nospam.com...
>
> 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.

Another way:

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



HTH

Jean-Guy

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

---Glenn

Dcount Did Not Work

=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)

"JR573PUTT" <JR573PUTT.23a9ry_1140028201.3161@excelforum-nospam.com> wrote
in message news:JR573PUTT.23a9ry_1140028201.3161@excelforum-nospam.com...
>
> 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?
>
>
> --
> JR573PUTT
> ------------------------------------------------------------------------
> JR573PUTT's Profile:
http://www.excelforum.com/member.php...o&userid=31587
> View this thread: http://www.excelforum.com/showthread...hreadid=512827
>