| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count on condition / Formula
Q1: I want to count how many of many data is under "panel" and in in "yellow"
colour. when I use =COUNTIF(A1:B6,"panel") it works and =COUNTIF(B2:B7,"yellow")) it also works but how to combine this two? Q2: some answer I saw posted =SUMPRODUCT(--(A1:A100="example"),--(B1:B100=2)). what is the "--" to be replaced with? appreciate your answer. thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count on condition / Formula
-- shouldn't be replaced with anything.
Is your first range really A1:B6 or A1:A6, if the latter then just use =SUMPRODUCT(--(A1:A6="panel"),--(B2:B7="yellow")) -- HTH RP (remove nothere from the email address if mailing direct) "SAM ONG" <SAM wrote in message ... Q1: I want to count how many of many data is under "panel" and in in "yellow" colour. when I use =COUNTIF(A1:B6,"panel") it works and =COUNTIF(B2:B7,"yellow")) it also works but how to combine this two? Q2: some answer I saw posted =SUMPRODUCT(--(A1:A100="example"),--(B1:B100=2)). what is the "--" to be replaced with? appreciate your answer. thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
| Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
| How can you use count with an array formula similar to using sum | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
