Counting values in two columns

Good morning!   Is there a way to count which rows in a worksheet contain: 1. A specific value in one column and 2. A formula in another column   Essentially a formula that does this: 1. =SUM...