How can I use references in SUMIFS()?
I would like to include the GAIN value if the .9T value is greater than the $ (price) value. The formula below gets "syntax error".
Don
Sonoma 14.0
MacBook Air (M1, 2020)
Question marked as
You have to use a new column (let's say Z for this demonstration) to hold the difference between .9T and $. Use this formula on all rows.
= '.9T'−B
Then your SUMIFS will be:
= SUMIFS(GAIN,Z,">0")
It is recommended to stop using SUMIF in favor of SUMIFS because the latter is more versatile and expandable.