Hi,
I have a SUMIFs statement that works but as it pulls data form an external sheet, erros out if I don't have both sheets open when I update.
I rarely use sumprodcuts but followed a guide to convert it and I get a value error. This is my original SumIf and resulting SumProduct. CAn anyone see what I'm doing wrong?
SUMIFS('[Cancellations Dashboard Report.xlsb]MainDataTable'!$Q:$Q,'[Cancellations Dashboard Report.xlsb]MainDataTable'!$D:$D,"A3S",'[Cancellations Dashboard Report.xlsb]MainDataTable'!$G:$G,"SMART",'[Cancellations Dashboard Report.xlsb]MainDataTable'!$A:$A,H$2,'[Cancellations Dashboard Report.xlsb]MainDataTable'!$B:$B,"MDS")
SUMPRODUCT(('[Cancellations Dashboard Report.xlsb]MainDataTable'!$D:$D="A3S")*('[Cancellations Dashboard Report.xlsb]MainDataTable'!$G:$G="SMART")*('[Cancellations Dashboard Report.xlsb]MainDataTable'!$A:$A=H$2)*('[Cancellations Dashboard Report.xlsb]MainDataTable'!$B:$B="MDS")*('[Cancellations Dashboard Report.xlsb]MainDataTable'!$Q:$Q))
Thanks
I have a SUMIFs statement that works but as it pulls data form an external sheet, erros out if I don't have both sheets open when I update.
I rarely use sumprodcuts but followed a guide to convert it and I get a value error. This is my original SumIf and resulting SumProduct. CAn anyone see what I'm doing wrong?
SUMIFS('[Cancellations Dashboard Report.xlsb]MainDataTable'!$Q:$Q,'[Cancellations Dashboard Report.xlsb]MainDataTable'!$D:$D,"A3S",'[Cancellations Dashboard Report.xlsb]MainDataTable'!$G:$G,"SMART",'[Cancellations Dashboard Report.xlsb]MainDataTable'!$A:$A,H$2,'[Cancellations Dashboard Report.xlsb]MainDataTable'!$B:$B,"MDS")
SUMPRODUCT(('[Cancellations Dashboard Report.xlsb]MainDataTable'!$D:$D="A3S")*('[Cancellations Dashboard Report.xlsb]MainDataTable'!$G:$G="SMART")*('[Cancellations Dashboard Report.xlsb]MainDataTable'!$A:$A=H$2)*('[Cancellations Dashboard Report.xlsb]MainDataTable'!$B:$B="MDS")*('[Cancellations Dashboard Report.xlsb]MainDataTable'!$Q:$Q))
Thanks