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"
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 |