ExcelBanter - Lookups and references in relation to countA, sumproducts

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Lookups and references in relation to countA, sumproducts (https://www.excelbanter.com/excel-programming/353410-lookups-references-relation-counta-sumproducts.html)

JR573PUTT[_2_]

Lookups and references in relation to countA, sumproducts

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

Trevor Shuttleworth

Lookups and references in relation to countA, sumproducts

=SUMPRODUCT((A2:A9=331)*(B2:B9<""))

etc

Regards

Trevor

"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=512829

Bob Phillips[_6_]

Lookups and references in relation to countA, sumproducts

See responses in excel.misc

--

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

All times are GMT +1. The time now is 01:11 PM.