I would help us to help you if you would attach a sample workbook with the working and non-working formulas applied. Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.