+2 Value for the text written twice on the same cell

Hi!

I have made a huge step forward from the formula i am currently using:

HTML Code: 

all thanks to TMS!

However, I dont know what to do if the same text is written twice on the same cell the return value is still 1.

I need the 2 return value if the text is written twice on a single cell.
Attached is the excel file for further reference.

Thanks!

Kind regards,
Rael

No attachment.

oops! heres the attachment.

Try

in G2

=SUMPRODUCT(((LEN($B$2:$B$25)-LEN(SUBSTITUTE($B$2:$B$25,$E3,"")))/LEN($E3)*(DATE(YEAR($E$1),MONTH($E$1),G$2)=$A$2:$A$25)))

Copy across and down

JohnTopley,

Thanks a lot! I don't know how, but it works

Best Regards!
Rael