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!

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!

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!

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!

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!