SUMIFS calculation

Richard@npdc
edited 12/09/19 in Smartsheet Basics

I have entered the current formula but get invalid operation, not sure why. Seems to be something with the >50000 as the formula works when I remove this.                                                 

 

=SUMIFS([1 July 18 - current]2:[1 July 18 - current]396, >50000, [Contract Status]2:[Contract Status]396, "red")

Help would be appreciated.

Comments

  • sean59916
    sean59916 ✭✭✭

    Hi, 



    It looks like you are missing the range part of the formula (or the cells that you wish to sum if the conditions are met.

    SUMIFS(Range, Criterion_range1, Criterion1, [Criterion_range2, Criterion2, ..])

    I hope this helps,

    Sean