NOT Operator Functionality

Sigma Formulas and Functions

ztrean August 21, 2020, 5:59pm #1

I’m trying to use the NOT operator but i’m getting an error, do you see something that is wrong with the formula below?

SumIf([Revenue],In([Stock],“C2”) NOT In([Company Name],“Leo Limited”))

Ryan August 21, 2020, 6:01pm #2

Hey Zachary!

I believe the issue here is that you do not have an “AND” operator before your “NOT”. If you add this I think it should work!

system automatically bumped October 14, 2020, 7:44am #3

system automatically bumped October 28, 2020, 1:20am #4

system automatically bumped November 13, 2020, 1:34am #5

system automatically bumped December 2, 2020, 2:03pm #6

system automatically bumped December 22, 2020, 2:20am #7

system automatically bumped January 11, 2021, 6:10am #8

system automatically bumped January 31, 2021, 2:18pm #9

system automatically bumped February 22, 2021, 12:13am #10