Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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)

Posted on Dec 27, 2023 11:12 AM

Reply
2 replies
Sort By: 

Dec 27, 2023 4:02 PM in response to ddweller151

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.

Reply

How can I use references in SUMIFS()?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.