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. =SUMPRODUCT(--ISFORMULA(D:D))

as well as 

2. =COUNTIF(C:C,A32)

in the same string.

Thank you.