You're just trying to count the number of rows that have "Blast Email" in C? The equation in your first sheet was fine, it just did not include two rows, 7 and 8.

Oh wait...I guess I get it. You want the number of rows with Blast Email and distinct column B numbers. Let me ponder that.