Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counif with two conditions
range a1:a3 contains paid, paid, paid, outs, denied respectively
range b1:b3 contains 12, 15, 10, 3, 4 i want to count if it is paid and less than 14. so the result of my countif should be 2. that is row 1 and 3. how will i do that? -- rp |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
counif with two conditions
=SUMPRODUCT(--(A1:A3="paid"),--(B1:B3<14))
-- HTH RP "rp" wrote in message ... range a1:a3 contains paid, paid, paid, outs, denied respectively range b1:b3 contains 12, 15, 10, 3, 4 i want to count if it is paid and less than 14. so the result of my countif should be 2. that is row 1 and 3. how will i do that? -- rp |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
counif with two conditions
it works!! exactly what i want. thanks!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counif multiple condition | Excel Worksheet Functions | |||
counif greater or less than | Excel Worksheet Functions | |||
Counif | Excel Discussion (Misc queries) | |||
counif but not all the cells | Excel Worksheet Functions | |||
Application.CounIf | Excel Programming |