Formula Problem Summing With Multiple Criteria

Hi folks, I'm having a real challenge creating a forumla to do what I need it to do and am hoping someone can help.

In Excel 2010 I have a woekbook with several sheets On one sheet I have several columns making up a sales forecast. The columns include a text field, and number field, 2 percentage fields, and a total. What I want to do is get a grand total for all entries that meet certain criteria in several columns and enter it into a cell in a different sheet..

I've tried several variations and mostly get eihter #Value or 0. The last attempt used this formula:

=SUM(IF('90 Day Forecast'!C5:C34="e",IF('90 Day Forecast'!F5:F34=1,IF('90 Day Forecast'!H5:H34>=50,IF('90 Day Forecast'!I5:I34>=75,'90 Day Forecast'!J5:J34)))))

This gives me 0 (there definitely data in the cells its checking) but other attempts have shown a VALUE error. Any suggestions?

Thanks!