I don't quite follow you...

Blueagm wrote:
Look at Data in D & E. If blank, and if column C = "studio", then count
occurrences.

C D E
Studio Allen Barnes
Private Jones
Studio
Double Hayes Hayes
Studio Taylor
In this case, the answer should be (3).

3 is the number of occurrences of "studio" with no other conditions. If
the count depends on blanks in D & E, wouldn't the answer be 2?

[snipped]