If Blank Formula

Shannon Lacerda ✭✭

09/28/21 in Formulas and Functions

Can someone help 'I am trying to add up a Value Column (2021 Opportunity Log Range 1) with the criteria

if the (Estimator) column is NOT blank and the (RANK) column has a "A" in it.

My formula above I get the below

0 · Share on FacebookShare on Twitter

Sign in

Try for free

Answers

• 

  Dale Murphy Community Champion

  09/28/21

  @Shannon Lacerda I think you need to use SUMIFS not SUMIF ...

  Dale

  0 · Share on FacebookShare on Twitter
• 

  Shannon Lacerda ✭✭

  09/28/21

  @Dale Murphy unfortunately I tried that as well, I get #INVALID OPERATION when I use SUMIFS

  0 · Share on FacebookShare on Twitter
• 

  Dale Murphy Community Champion

  09/28/21

  @Shannon Lacerda Can I see the SUMIFS formula you tried? The structure is a bit different ...

  Dale

  0 · Share on FacebookShare on Twitter
• 

  Shannon Lacerda ✭✭

  09/28/21

  @Dale Murphy

  

  
  

  0 · Share on FacebookShare on Twitter
• 

  Shannon Lacerda ✭✭

  09/28/21

  @Dale Murphy thanks I moved the formula around and it works thanks

  1 · Share on FacebookShare on Twitter

Sign in

Try for free

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list