Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with two criteria
How can i count rows with two criteria. I can use COUNTIF with only one
criteria... does it posible to count with two criteria.. For example, I need to count the A's in the column A1:A100 which satisfies the condition "O" in column D1:D100. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with two criteria
=SUMPRODUCT((A1:A100="A")*(D1:D100="O"))
Regards Trevor "Boran Düzgün" wrote in message ... How can i count rows with two criteria. I can use COUNTIF with only one criteria... does it posible to count with two criteria.. For example, I need to count the A's in the column A1:A100 which satisfies the condition "O" in column D1:D100. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with two criteria
See response in
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Boran Düzgün" wrote in message ... How can i count rows with two criteria. I can use COUNTIF with only one criteria... does it posible to count with two criteria.. For example, I need to count the A's in the column A1:A100 which satisfies the condition "O" in column D1:D100. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with two criteria
See response in public.excel
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Boran Düzgün" wrote in message ... How can i count rows with two criteria. I can use COUNTIF with only one criteria... does it posible to count with two criteria.. For example, I need to count the A's in the column A1:A100 which satisfies the condition "O" in column D1:D100. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel COUNTIF Function - a range as criteria ? | Excel Worksheet Functions | |||
countif criteria only one word of few doesn't work | Excel Worksheet Functions | |||
Countif w/ Multiple Criteria | Excel Worksheet Functions | |||
countif variable criteria | Excel Discussion (Misc queries) | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions |