Hello,

I have several if statements which I want to add and they are as follows:
=(IF(L3="","",IF(K3="",D3,K3))) + (IF(L4="","",IF(K4="",D4,K4))) + (IF(L5="","",IF(K5="",D5,K5))) + (IF(L6="","",IF(K6="",D6,K6)))+so on up to 38.

I was wondering instead of adding each IF statement separately, is there any formula that would make my life easier and shorten it?

Thanks in advance.