Home |
Search |
Today's Posts |
#1
|
|||
|
|||
combined two countif functions
I want to have a table as such:
state population CO 100 NE 200 CO 300 I want to count the number of times state is CO and Population is 200. In the example it should result in a count of 1. How do i formulate this? thanks. |
#2
|
|||
|
|||
Hi Geoff
Try this: =SUMPRODUCT((A1:A3="CO")*(B1:B3200)) HTH Michael Mitchelson "Geoff" wrote: I want to have a table as such: state population CO 100 NE 200 CO 300 I want to count the number of times state is CO and Population is 200. In the example it should result in a count of 1. How do i formulate this? thanks. |
#3
|
|||
|
|||
=SUMPRODUCT(--(A2:a100="CO"),--(B2:B100200))
-- HTH RP (remove nothere from the email address if mailing direct) "Geoff" wrote in message ps.com... I want to have a table as such: state population CO 100 NE 200 CO 300 I want to count the number of times state is CO and Population is 200. In the example it should result in a count of 1. How do i formulate this? thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Functions IF, AND, COUNTIF, MATCH | Excel Worksheet Functions | |||
help please - complex countif, etc. functions | Excel Worksheet Functions | |||
COUNTIF functions | Excel Worksheet Functions | |||
Can you combined the SUMIF and SUBTOTAL functions in a formula? | Excel Worksheet Functions | |||
How do I combine COUNTIF and AND functions in Excel | Excel Worksheet Functions |