Forum Discussion

Tamara Duvall's avatar
Tamara Duvall
Copper Contributor
Apr 18, 2020
Solved

!SPILL error with SUMIFS formula

This worksheet (produced in Office 365) is part of a larger workbook that I am putting together to produce monthly financials.  There is a worksheet named transactions_data which is being searched to...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 18, 2020

    Tamara Duvall 

    That's since you have an array as latest condition. If you'd like to have OR condition, wrap entire formula with sum, i.e. =SUM(SUMIFS(...))

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 18, 2020

Tamara Duvall 

That's since you have an array as latest condition. If you'd like to have OR condition, wrap entire formula with sum, i.e. =SUM(SUMIFS(...))

Tamara Duvall's avatar
Tamara Duvall
Copper Contributor
Apr 18, 2020

Thank you so much! The =SUM option worked beautifully.