sumifs with multiple columns

[daveyc18]

ABS(SUMIFS('INV36'!AA:AA,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG"))

SUBTRACT


SUMIFS('INV36'!AK:AT,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG")

trying to use AK to AT, but doesnt seem to work....so right now my formula looks like this:

LOL


ABS(SUMIFS('INV36'!AA:AA,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG"))-((SUMIFS('INV36'!AK:AK,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG")+(SUMIFS('INV36'!AL:AL,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG")+(SUMIFS('INV36'!AM:AM,'INV36'!AN:AN,D4,'INV36'!F:F,"COMMON OPT ELG")+(SUMIFS('INV36'!AO:AO,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG")+(SUMIFS('INV36'!AP:AP,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG")+(SUMIFS('INV36'!AQ:AQ,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG")+(SUMIFS('INV36'!AR:AR,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG")+(SUMIFS('INV36'!AS:AS,'INV36'!AE:AE,D4,'INV36'!F:F,"COMMON OPT ELG")+(SUMIFS('INV36'!AS:AS,'INV36'!AT:AT,D4,'INV36'!F:F,"COMMON OPT ELG"))))))))))))

 

[dreid1011]

See if this works for your second formula:

SUM(FILTER(INV36!AK:AT,(INV36!AE:AE=D4)*(INV36!F:F="COMMON OPT ELG")))