Here are the formulas:

=IF(AND(SUM(D3:L3)>9,(SUM(D3:L3)<14),SUM(D3:E3)>0,SUM(F3:G3)>0),"$50","$0")

=IF(AND(SUM(D3:L3)>14,SUM(D3:L3)>0,SUM(F3:G3)>0),"$75","$0")

=IF(AND(SUM(D3:L3)>9,SUM(D3:L3)<14,SUM(H3:L3)>0),"$75","$0")

=IF(AND(SUM(D3:L3)>14,SUM(H3:L3)>0),"$100","$0")

here's the sheet with all the cells so the columns and numbers make sense:

Data 1 | Data 2 | Date | Date | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 | Field 8 | Field 9 | Commission | Bonus $50 | Bonus $75 | Bonus $75 | Bonus $100 | Bonus Fields Combined |

0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $0 | $0 | $0 | $0 | |||||

0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $0 | $0 | $0 | $0 | |||||

0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $0 | $0 | $0 | $0 | |||||

0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $0 | $0 | $0 | $0 | |||||

0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $0 | $0 | $0 | $0 | |||||

Grand Total | N/A | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $ - | $ - | $ - | $ - |

Thank you for the help!

JohnB