ExcelBanter - Help with Countif

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

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

- - Help with Countif (https://www.excelbanter.com/excel-discussion-misc-queries/149058-help-countif.html)

Qaspec

Help with Countif

I am trying to count the number of times red shows up in my list of data if
red is "open"

ColumnA ColumnB
Color Type

Red Open
Red Closed
Blue Open
Green Closed
Red Open

According to this list the answer should be 2. Thanks for your help.

JE McGimpsey

Help with Countif

One way:

=SUMPRODUCT(--(A2:A1000="Red"),--(B2:B1000="Open"))

In article ,
Qaspec wrote:

I am trying to count the number of times red shows up in my list of data if
red is "open"

ColumnA ColumnB
Color Type

Red Open
Red Closed
Blue Open
Green Closed
Red Open

According to this list the answer should be 2. Thanks for your help.

Toppers

Help with Countif

=SUMPRODUCT(--(A1:A10)="Red"),--(B1:B10="Open"))

"Qaspec" wrote:

I am trying to count the number of times red shows up in my list of data if
red is "open"

ColumnA ColumnB
Color Type

Red Open
Red Closed
Blue Open
Green Closed
Red Open

According to this list the answer should be 2. Thanks for your help.

Mike H

Help with Countif

Try:-

=SUMPRODUCT((A1:A10="Red")*(B1:B10="Open"))

Mike

"Qaspec" wrote:

I am trying to count the number of times red shows up in my list of data if
red is "open"

ColumnA ColumnB
Color Type

Red Open
Red Closed
Blue Open
Green Closed
Red Open

According to this list the answer should be 2. Thanks for your help.

All times are GMT +1. The time now is 08:15 PM.