Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif with more than one criteria
Hi. I need to countif with more than one criteria, how do I do that?
Speadsheet Example: Column A Column B Novi 13 Novi 13 North 13 In this example I want to count only when Column A = Novi. Maybe a different formula is appropriate. Thanks |
#2
|
|||
|
|||
Countif with more than one criteria
This looks like a standard COUNTIF to me
=COUNTIF(A:A,"Novi") -- HTH RP (remove nothere from the email address if mailing direct) "Bleeding Maroon" wrote in message ... Hi. I need to countif with more than one criteria, how do I do that? Speadsheet Example: Column A Column B Novi 13 Novi 13 North 13 In this example I want to count only when Column A = Novi. Maybe a different formula is appropriate. Thanks |
#3
|
|||
|
|||
Countif with more than one criteria
My Example wasn't clear here's a better one
Column A Column B Novi 13 Novi 13 North 13 I need a formula that counts only when Column B = 13 and Column A = Novi "Bob Phillips" wrote: This looks like a standard COUNTIF to me =COUNTIF(A:A,"Novi") -- HTH RP (remove nothere from the email address if mailing direct) "Bleeding Maroon" wrote in message ... Hi. I need to countif with more than one criteria, how do I do that? Speadsheet Example: Column A Column B Novi 13 Novi 13 North 13 In this example I want to count only when Column A = Novi. Maybe a different formula is appropriate. Thanks |
#4
|
|||
|
|||
Countif with more than one criteria
Hi
Try =SUMPRODUCT(--($A$1:$A$100="novi"),--($B$1:$B$100=13)) This assumes that the 13 is a numeric value, not text. If it is text, then wrap the 13 in double quotes "13". Regards Roger Govier Bleeding Maroon wrote: My Example wasn't clear here's a better one Column A Column B Novi 13 Novi 13 North 13 I need a formula that counts only when Column B = 13 and Column A = Novi "Bob Phillips" wrote: This looks like a standard COUNTIF to me =COUNTIF(A:A,"Novi") -- HTH RP (remove nothere from the email address if mailing direct) "Bleeding Maroon" wrote in message ... Hi. I need to countif with more than one criteria, how do I do that? Speadsheet Example: Column A Column B Novi 13 Novi 13 North 13 In this example I want to count only when Column A = Novi. Maybe a different formula is appropriate. Thanks |
#5
|
|||
|
|||
Countif with more than one criteria
Use DCUONT/DCOUNTA function. For example use this formula:
=DCOUNTA(Database,"Column A",D1:E2), Where Database is range of your data and range D1:E2 contains counting criteria with column headings. In your example it should be: Column A Column B Novi 13 "Bleeding Maroon" wrote in message ... My Example wasn't clear here's a better one Column A Column B Novi 13 Novi 13 North 13 I need a formula that counts only when Column B = 13 and Column A = Novi "Bob Phillips" wrote: This looks like a standard COUNTIF to me =COUNTIF(A:A,"Novi") -- HTH RP (remove nothere from the email address if mailing direct) "Bleeding Maroon" wrote in message ... Hi. I need to countif with more than one criteria, how do I do that? Speadsheet Example: Column A Column B Novi 13 Novi 13 North 13 In this example I want to count only when Column A = Novi. Maybe a different formula is appropriate. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions |