Hello,

I'm trying to create a sumifs formula where one of the conditions is to compare the account number (in the form of xx-xx-xxx) to an acceptable list of accounts on a separate tab. Is this possible? I can't share the data, but here's the formula I'm trying to use:

=SUM(SUMIFS('Data Current'!$D:$D,'Data Current'!$C:$C,Accts!B66:B131, 'Data Current'!$A:$A, "*" & $B3 & "*"))

Data Current'!$C:$C is the account number of the record.
Accts!B66:B131 is the list of accounts that are applicable.

Everything else in the formula seems to work.

Thanks!