Got myself in muddle. I have the code below.

I want to search all those records in column F with less than 12 characters
but only for that month and year identified by cells H5 and J5 respectfully.
i get a result but it is way off.

=SUMPRODUCT(--(LEN(Sheet1!$F2:$F30000)<12),--(MONTH(Sheet1!$I$2:$I$30000)=H5),--(YEAR(Sheet1!$I$2:$I$30000)=J5))/(F12+G12+H12+I12+J12+K12)

cells F12,G12,H12,I12,J12,K12 just contain raw data.

Any ideas? I think I have got lost with the brackets.

--
Regards vipa