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!
Bookmarks