I have a SUM IF formula that looks like this (there are additional sumifs criteria but removed them to keep example short)
=SUMIFS('Data Pull'!$K$12:$K$24363,'Data Pull'!$C$12:$C$24363, $D12)
Where D12 contains 51*
Thus it only sums accounts that start with 51.
I later wanted to to do the same thing with multiple accounts
Say D12 contains an array of accounts or other comma separated lists.
I knew i needed to operate on an array (but in this case no CTRL+SHIFT+ENTER)
=SUM(SUMIFS('Data Pull'!$K$12:$K$24363,'Data Pull'!$C$12:$C$24363, {"51*","55*","57*"} ))
This worked but I would really like to put that array in D12 so D12 = {51*,55*,57*}
and the SUM/SUMIFs referenced the cell.
=SUM(SUMIFS('Data Pull'!$K$12:$K$24363,'Data Pull'!$C$12:$C$24363, D12 ))
i have tired changing how the list/array in D12 was representing and variations of this formula, but so far nothing, and tried to change things based on what I saw with Evaluate Formula, but so far nothing has worked.
How can I reference an array instead of a single value?
Any thoughts?
Alan
=SUMIFS('Data Pull'!$K$12:$K$24363,'Data Pull'!$C$12:$C$24363, $D12)
Where D12 contains 51*
Thus it only sums accounts that start with 51.
I later wanted to to do the same thing with multiple accounts
Say D12 contains an array of accounts or other comma separated lists.
I knew i needed to operate on an array (but in this case no CTRL+SHIFT+ENTER)
=SUM(SUMIFS('Data Pull'!$K$12:$K$24363,'Data Pull'!$C$12:$C$24363, {"51*","55*","57*"} ))
This worked but I would really like to put that array in D12 so D12 = {51*,55*,57*}
and the SUM/SUMIFs referenced the cell.
=SUM(SUMIFS('Data Pull'!$K$12:$K$24363,'Data Pull'!$C$12:$C$24363, D12 ))
i have tired changing how the list/array in D12 was representing and variations of this formula, but so far nothing, and tried to change things based on what I saw with Evaluate Formula, but so far nothing has worked.
How can I reference an array instead of a single value?
Any thoughts?
Alan