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...