SUMIFS calculation

Richard@npdc

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.

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