Combining SUMIF( and AND( Formulas

kateprew

I am attempting to sum a large amount of data into totals based on unit, month, general ledger title, so for example: get a total $ amount for Misc Income in the month of July for X Unit. I'm getting an #UNPARSEABLE error. Are there any clear errors here? I cannot figure it out.

=SUMIF({CEAS Budget v Actuals Testing Range 2}, AND({CEAS Budget v Actuals Testing Range 3="Jul"}, {CEAS Budget v Actuals Testing Range 4}=[Revenue and Expenses]@row },{CEAS Budget v Actuals Testing Range 6}="CEAS Co-op"), {CEAS Budget v Actuals Testing Range 5})

• CEAS Budget v Actuals Testing Range 2 = the whole imported spreadsheet with the data
• CEAS Budget v Actuals Testing Range 3 = Period column
• CEAS Budget v Actuals Testing Range 4 = GL Name column
• CEAS Budget v Actuals Testing Range 6 = Unit Name column
• CEAS Budget v Actuals Testing Range 5 = Budget $ Amount column

Thanks in advance for any help!

Shanky Paul

There’s a stray } after [Revenue and Expenses]@row that will cause #UNPARSEABLE error.


Use SUMIFs instead of SUMIF. Try the below corrected formula and see if this works.

=SUMIFS({CEAS Budget v Actuals Testing Range 5}, {CEAS Budget v Actuals Testing Range 3}, "Jul", {CEAS Budget v Actuals Testing Range 4}, [Revenue and Expenses]@row , {CEAS Budget v Actuals Testing Range 6}, "CEAS Co-op")