| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| COUNTIF | Excel Discussion (Misc queries) | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Linear Mode
