Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I count number of cels the matches 2 conditions (I am using COUNTIF
and AND) ??? I need the total of cels that matches the 2 conditions and not the sum of the cels. Thanks |
#2
![]() |
|||
|
|||
![]()
=SUMPRODUCT(--(A1:A100="value1"),--(A1:A100="value2"))
-- HTH RP (remove nothere from the email address if mailing direct) "Abra" wrote in message ... How do I count number of cels the matches 2 conditions (I am using COUNTIF and AND) ??? I need the total of cels that matches the 2 conditions and not the sum of the cels. Thanks |
#3
![]() |
|||
|
|||
![]()
You could use Countif() in conjunction with Sum() to count against any
number of conditions: =SUM(COUNTIF(A1:A100,{"cond#1","cond#2","cond#3"}) ) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Abra" wrote in message ... How do I count number of cels the matches 2 conditions (I am using COUNTIF and AND) ??? I need the total of cels that matches the 2 conditions and not the sum of the cels. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions | |||
Count number of days in given month? | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count number of shaded cells | Excel Discussion (Misc queries) |