ExcelBanter - count 2 column

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - count 2 column (https://www.excelbanter.com/excel-discussion-misc-queries/166870-count-2-column.html)

Jason Au Yeung

count 2 column

I would like to count following criteria. Do there any formula can help IN
Excel ?

Closed LCD
Closed LCD
Open LCD
Open LCD
Open LCD
Open Desktop
Open Desktop

I would like to get the total which is (Open , Desktop). In this case, it
should be 2.

Thanks very much

Gary''s Student

count 2 column

=SUMPRODUCT(--(A1:A100="open"),--(B1:B100="desktop"))

--
Gary''s Student - gsnu200758

EricBB

count 2 column

=sumproduct(--(A1:A10="Open"),--(B1:B10='Desktop"))
adjust the range to suit ur needs.
EricBB

"Jason Au Yeung" wrote:

I would like to count following criteria. Do there any formula can help IN
Excel ?

Closed LCD
Closed LCD
Open LCD
Open LCD
Open LCD
Open Desktop
Open Desktop

I would like to get the total which is (Open , Desktop). In this case, it
should be 2.

Thanks very much

All times are GMT +1. The time now is 04:29 AM.