Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif dependent on two columns
I've gone through all the previous messages and tried very hard to impliment
the suggestions to help me with my issue. I'm trying to count if one column has a certain criteria, count the other column. For example: column b column x Red 75.00 Blue 25.00 Red 50.00 Green 125.00 Blue Red 75.00 Therefore, I want to count if column B is noted as "Red", and has a dollar amount in column x. Doesn't matter how much. Please help and thank you for your assistance. Cathy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif dependent on two columns
Nevermind... I figured it out.
You guys are great here...I used the following: =SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40)) This was recommended by "Toppers" in a previous post. Thank you! "katierb40" wrote: I've gone through all the previous messages and tried very hard to impliment the suggestions to help me with my issue. I'm trying to count if one column has a certain criteria, count the other column. For example: column b column x Red 75.00 Blue 25.00 Red 50.00 Green 125.00 Blue Red 75.00 Therefore, I want to count if column B is noted as "Red", and has a dollar amount in column x. Doesn't matter how much. Please help and thank you for your assistance. Cathy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif dependent on two columns
Maybe something like this:
=SUMPRODUCT(--(B1:B100="Red"),--(X1:X100<"")) HTH, Paul -- "katierb40" wrote in message ... I've gone through all the previous messages and tried very hard to impliment the suggestions to help me with my issue. I'm trying to count if one column has a certain criteria, count the other column. For example: column b column x Red 75.00 Blue 25.00 Red 50.00 Green 125.00 Blue Red 75.00 Therefore, I want to count if column B is noted as "Red", and has a dollar amount in column x. Doesn't matter how much. Please help and thank you for your assistance. Cathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif in 2 columns | Excel Discussion (Misc queries) | |||
Selecting worksheet dependent on columns drop down list | Excel Discussion (Misc queries) | |||
countif dependent on two columns? | Excel Discussion (Misc queries) | |||
How do I sum a column dependent on another columns text value? | Excel Worksheet Functions | |||
Conditional count of rows dependent on multiple columns | Excel Worksheet Functions |