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

try COUNTA


--
jhct
------------------------------------------------------------------------
jhct's Profile: http://www.excelforum.com/member.php...o&userid=31562
View this thread: http://www.excelforum.com/showthread...hreadid=512827

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


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=512827

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

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=512827

Dcount Did Not Work


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=512827

=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" wrote
in message ...

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

"JR573PUTT" wrote
in message ...

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's Profile: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=512827

"JR573PUTT" wrote
in message ...

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


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=512827