Using Countifs to count a string

[mecerrato]

I have this formula that I use to count the amount of loans that are "FHA Fixed" but it is counting every instance that it finds the words "FHA Fixed". I want to only count if FHA Fixed is together but it is counting the row if it contains the words "FHA Fixed" anywhere in the column.

Can someone help me tweak this formula?

Formula I am using:
=COUNTIFS(Fundings!$E$2:$E$150000,$B$21,Fundings!$AF$2:$AF$150000,"=" & "*FHA Fixed*",Fundings!$V$2:$V$150000,">="&$B23,Fundings!$V$2:$V$150000,"<"&EDATE($B23,1))
The data us below, the result I desire is a count of 1 loan because there is only 1 "FHA Fixed" but it is also counting the row that has "im FHA Bond Conforming Fixed 30 Year"

Product Name

im BROKERED QUORUM HELOC

Conv Fixed 30 Year

FHA Fixed 30 Year

Conv Fixed 30 Year

Conv Fixed 30 Year

Conv Fixed 30 Year

im FHA Bond Conforming Fixed 30 Year

 

[Fluff]

but it is also counting the row that has "im FHA Bond Conforming Fixed 30 Year"

No it isn't, you must have another row that matches the criteria.

 

[nemmi69]

You could replace with =SUMPRODUCT(--EXACT("FHA Fixed", Fundings!$V$2:$V$150000))

 

[Fluff]

That won't work as it should count "FHA Fixed 30 Year"

 

[mecerrato]

No it isn't, you must have another row that matches the criteria.

I double checked the data and you pointed out a rookie mistake, I was referencing the wrong cell for the date, once I corrected I got the right result.
One more question though, is there a way of counting if it either has "FHA or FIxed" or "VA Fixed"?
Let me know if you think I should post it as a different thread.

 

[Fluff]

How about

=sum(COUNTIFS(Fundings!$E$2:$E$150000,$B$21,Fundings!$AF$2:$AF$150000,{"*FHA Fixed*","*VA Fixed*"},Fundings!$V$2:$V$150000,">="&$B23,Fundings!$V$2:$V$150000,"<"&EDATE($B23,1)))

 

[mecerrato]

How about

=sum(COUNTIFS(Fundings!$E$2:$E$150000,$B$21,Fundings!$AF$2:$AF$150000,{"*FHA Fixed*","*VA Fixed*"},Fundings!$V$2:$V$150000,">="&$B23,Fundings!$V$2:$V$150000,"<"&EDATE($B23,1)))

This worked but I always thought that if you are using a curly brace that means it is a CSE formula but this one worked without the CSE.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[mecerrato]

This worked but I always thought that if you are using a curly brace that means it is a CSE formula but this one worked without the CSE.

Oh and thank you very much for your help

 

[Fluff]

Can you please answer my question & update your account details.