SUMIF, NOT Function, excluding specific text in return


Hi All,

Hoping someone may be able to help with the final section of the below formula.

it works as it should up unit the last bit.

Aim of the formula:

Sum of "ScheduleValue"


ScheduleWCDeliveryDate is more than 01/12/2020 (Works)

ScheduleWCDeliveryDate is less than 30/12/2020 (Works)

ScheduledDespatchDate is Blank (Works)

ScheduledStatus does not Equal "Cancelled" (Invalid Op)

This is what I have, which worked, until entering the last section.

Any advice on how to edit would be greatly appreciated, I'm unfamiliar with the NOT function.

I tried combining with CONTAINS but similar result!

=SUMIFS({ScheduleValue}, {ScheduleWCDeliveryDate}, >=DATE(2020, 12, 1), {ScheduleWCDeliveryDate}, <=DATE(2020, 12, 30), {ScheduleDespatchDate}, "", {ScheduleStatus}, NOT("CANCELLED"))

Thanks in advanced,



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!