SUMIFS Function for multiple condition in a column with multiple criteria

Options

Hi Team,

I am working on a data wherein I have Value in CSPBU Boost Requests Range5 that need to added only when Criteria1 - if CSPBU Boost Requests Range3 is Approved inn a Column, and if In CSPBU Boost Requests Range2 either we have Lost or Cancelled.

=SUMIFS({CSPBU Boost Requests Range 5}, {CSPBU Boost Requests Range 3}, "Approved", {CSPBU Boost Requests Range1},"Lost" OR Cancelled")

The above formula is not working please suggest


Thanks

Anil Raghav

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!