This one should be simple, but I am obviously doing something wrong.
Current formula:
=IF(AND(K12="",L12="",M12="",N12=""),"",((K12+M12)*I3)+((L12+N12)*J3))
This works if All K12:N12 are empty or they all have data, the problem is when 1, 2 or 3 doesn't have data should be simply left out of the final calculation.
For informational purposes, I3 and J3 is simply a multiplier for K and M then L and N respectively. If both K & M are empty, it doesn't need to multiply it. Same with L and N for J3.
Hope I didn't confuse anyone. Pretty dead tired and up too late.
Thanks for the help.
RJ