Help with counting formula

[AL789]

Hi there. I need some help with a formula to count a projects based on criteria in two different columns.

See attached for what I'm looking for. I tried a previously suggested formula, though it counts DKNS projects as a 1 for some reason.

Suggestions?

Thanks!!

Help?

[#2 · Accepted solution]

@AL789 

The problem lies in the fact that all your entries in column C are texts. "DKNS" also qualifies as it is seen as greater than one (i.e. >1). Make sure that you enter revenues as numbers and then test for numbers in column C.

{=SUM(IF((Table1[Central Region: Expand]="Expand")+ISNUMBER((Table1[Central Region:
Expand: Sales revenue $])),1,0))}

 Attached a revised schedule with the working formula.