Dyanmic Range Sumifs.txt - =SUMIFS(INDEX[2017 CC Sales...

This preview shows page 1 out of 1 page.

=SUMIFS(INDEX('[2017 CC Sales plan.xlsx]CCTM_Working file'!$G:$V,0,MATCH(VLOOKUP($A494,'[2017 CC Sales plan.xlsx]Sheet1'!$M$1:$N$12,2,FALSE),'[2017 CC Sales plan.xlsx]CCTM_Working file'!$G$1:$V$1,0)),'[2017 CC Sales plan.xlsx]CCTM_Working file'!$D:$D,$D494,'[2017 CC

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture