CountIfs any value in a column starts with the value in another column

Hello,

I have the following formula:

Formula:

Please Login or Register  to view this content.

I need to change the 'Renewal Chart'!$B:$B,$B20 part to any value that starts with B20

So if B20 if A1 and in column B of Renewal Chart there is a A1 and and A1-DL it will count both.

Thanks in advance!

Try changing $B20 to $B20&"*"

Try

=COUNTIFS('Renewal Chart'!$L:$L,"",'Renewal Chart'!$B:$B,"*" &$B20 &"*",'Renewal Chart'!$I:$I,EOMONTH(H$17,0))

Thanks All! That Did it. I was trying "$B20*" I still have a lot to learn.

You're welcome.