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!
|