Hi ,Hii ,
See if this ok ?
cell E4;
=IF(AND(B4<>0,C4<>0),F4+G4+H4+I4+L4+M4,IF(AND(B4<>0,C4=0),F4+G4+H4+I4+J4+K4+L4+M4,IF(AND(B4=0,C4<>0),F4+L4+M4,IF(AND(B4=0,C4=0),F4+J4+K4+M4))))
Regards
Rahul shewale
Hi Rahul shewale,.........
=IF(AND(B4<>0,C4<>0),F4+G4+H4+I4+L4+M4,IF(AND(B4<>0,C4=0),F4+G4+H4+I4+J4+K4+L4+M4,IF(AND(B4=0,C4<>0),F4+L4+M4,IF(AND(B4=0,C4=0),F4+J4+K4+M4))))
Regards
Rahul shewale