| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditions and count occurrences of "not blank"
If column A has occurrences of "c", then look at that row in column B, and
count, wherever B is not blank. Basically, I want to count everyone who joined at the "conductors level" (occurrences of "c" in column A), who has a child in the elementary music program (column B wherever not blank). I'm so frustrated. Please help me! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditions and count occurrences of "not blank"
Try this:
=SUMPRODUCT((A1:A50="c")*(B1:B50<"")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "learning" wrote in message ... If column A has occurrences of "c", then look at that row in column B, and count, wherever B is not blank. Basically, I want to count everyone who joined at the "conductors level" (occurrences of "c" in column A), who has a child in the elementary music program (column B wherever not blank). I'm so frustrated. Please help me! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditions and count occurrences of "not blank"
Try
=SUMPRODUCT(--(A1:A100="c"),--(B1:B100<"")) extend ranges as necessary "learning" wrote: If column A has occurrences of "c", then look at that row in column B, and count, wherever B is not blank. Basically, I want to count everyone who joined at the "conductors level" (occurrences of "c" in column A), who has a child in the elementary music program (column B wherever not blank). I'm so frustrated. Please help me! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditions and count occurrences of "not blank"
Learning....the answers above are true....yet dont hit the spacebar on any
cell in column B if u wish it as blank, if you ddid - u may see it as blank but it is not ? We all need to learn the hard way... "learning" wrote: If column A has occurrences of "c", then look at that row in column B, and count, wherever B is not blank. Basically, I want to count everyone who joined at the "conductors level" (occurrences of "c" in column A), who has a child in the elementary music program (column B wherever not blank). I'm so frustrated. Please help me! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditions and count occurrences of "not blank"
zzzzzz????/
"learning" wrote: If column A has occurrences of "c", then look at that row in column B, and count, wherever B is not blank. Basically, I want to count everyone who joined at the "conductors level" (occurrences of "c" in column A), who has a child in the elementary music program (column B wherever not blank). I'm so frustrated. Please help me! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count occurrences where 2 columns are required to be true? | Excel Worksheet Functions | |||
| how do I count occurrences of multiple conditions | Excel Worksheet Functions | |||
| how do I count the occurrences of multiple conditions | Excel Worksheet Functions | |||
| Count using 2 conditions, one of which being a "less than or equal to" - URGENT | Excel Discussion (Misc queries) | |||
| COUNT using multiple conditions | Excel Discussion (Misc queries) | |||
Linear Mode
