{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 SAY GOODBYE 的问题《Excel sum based on matrix condition》','https://www.manongdao.com/q-995865.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I need to create dynamic sum formula in Excel with conditions based on a matrix table. I've represented an example below:
The sum val is based on what is selected in the matrix with an 'X'. If the 'X' changes to other references, the formula should be changed to reflect the change and sum the relevant values.
Any ideas?
Please try: