Try
=Sumproduct(--(B1:B100="AS2"),--(D1:D100="MCT"),--(E1:E1000))
This will give you the non zero count

If you want the sum then
Sumproduct(--(B1:B100="AS2"),--(D1:D100="MCT"),--(E1:E1000),(E1:E100))

Adjust the range according to your data.

There are innumerable posts on SUMPRODUCT on this forum.

"Desper84AnAnswer" wrote:

Formula: =COUNTIFS(B:B,"AS2",D:D,"MCT")

In column E (Total amount) - I have dollar values. I want to count all the
cells in this column that has a "$" sign. Or... I want the formula to
subtract any blank cells in this column so that it gives me a total number.
I've tried to use: =COUNTIFS(B:B,"AS2",D:D,"MCT",E:E,"$") - RESULT: "0"
(Which is incorrect)