Having Issue with 2nd Sumifs criteria, trying to add by date and matching accounting group

Brandon Togneri

ss.jpg

I need to add transactions a Year to Date Amount and by Accounting Group

David Joyeuse

Hi @Brandon Togneri

You do have brackets remaining in the last part of your formula.

Should be:

=SUMIFS({FR19 Range 3}, {FR19 Range 4}, AND(@cell>=DATE(2019,8,1),@cell<=TODAY(-365)), {FR19 Range 5}, "310.02 Membership Dues")

David Joyeuse

Hi @Brandon Togneri

You do have brackets remaining in the last part of your formula.

Should be:

=SUMIFS({FR19 Range 3}, {FR19 Range 4}, AND(@cell>=DATE(2019,8,1),@cell<=TODAY(-365)), {FR19 Range 5}, "310.02 Membership Dues")

Brandon Togneri

Thanks for the edit! Works perfectly.