Hello All,
I have a formula that works as I want combining sumif and sumproduct. However, I am referencing another workbooks so I would like to use only sumproducts to make this happen. I have excel 2019 and don't have any power query functions
=SUMPRODUCT(--(Mapping!$G$2:$G$213=$A32),SUMIFS('[Revenue by Charge Code.xlsx]Revenue by Charge Code'!$I:$I,'[Revenue by Charge Code.xlsx]Revenue by Charge Code'!$F:$F,Mapping!$D$2:$D$213,'[Revenue by Charge Code.xlsx]Revenue by Charge Code'!$E:$E,DAILY!D3))
Thank you!
I have a formula that works as I want combining sumif and sumproduct. However, I am referencing another workbooks so I would like to use only sumproducts to make this happen. I have excel 2019 and don't have any power query functions
=SUMPRODUCT(--(Mapping!$G$2:$G$213=$A32),SUMIFS('[Revenue by Charge Code.xlsx]Revenue by Charge Code'!$I:$I,'[Revenue by Charge Code.xlsx]Revenue by Charge Code'!$F:$F,Mapping!$D$2:$D$213,'[Revenue by Charge Code.xlsx]Revenue by Charge Code'!$E:$E,DAILY!D3))
Thank you!
