IF(AND) Calculation

[Big_Tater]

Can someone please tell me what I have wrong here. I keep getting an error saying I have an error. Am I trying to make this too complicated?

=IF(((D4=0,0,D4/D$137)*H$138)+IF((E4=0,0,E4/E$137)*H$139))


This one works fine, but now we want to know what was collected in the 1-15 and 16-31, so I need to look at the totals separately not sum'd any longer, so I am trying to adjust the formula to the above.
=IF(AND(D5=0,E5=0),0,(SUM(D5:E5)/SUM(D$137:E$137)))*H$137

Thanks for your help.

[mdbct]

Does this do what you want?

Please Login or Register  to view this content.

[Big_Tater]

Does this do what you want?

Please Login or Register  to view this content.

Perfect!! Problem solved!

I see that I had too many (( )) in my formula.

Thanks a lot for your help.

[shg]

Or just =D4 * H$138 / D$137 + H$139 * E4 / E$137

[Big_Tater]

Or just =D4 * H$138 / D$137 + H$139 * E4 / E$137

Thank you for the alternate solution "shg". Always nice to have multiple options.