I need the following formula to be simpified:
=IF(AND(A2="",A3="",A4="",A5="",A6="",A7="",A8="",A9="",A10="",A11="",A12="",A13="",A14="",A15="",A16="",A17=""),"",SUM((A2*C2),(A3*C3),(A4*C4),(A5*C5),(A6*C6),(A7*C7),(A8*C8),(A9*C9),(A10*C10),(A11*C11),(A12*C12),(A13*C13),(A14*C14),(A15*C15),(A16*C16),(A17*C17)))
I have attached an example, so you can see how the formula is being used.
Thanks.
Bookmarks