How to SUMIF in Smartsheet with multiple criteria requirements from one column

Options

I am having difficulty transferring the formula below from Excel over to Smartsheet.

Below is the current formula I need from Excel. I need Smartsheet to produce the same result. I'm new to Smartsheet and have gone through the self-help videos, directions, and pop-ups to see if I can get the formula below to work in Smartsheet, but I wasn't able to figure out how to accomplish this. If you know how to make this happen, I will highly appreciate your help. Thank you in advance for your help.

=SUM(SUMIF($H$40:$H$79,{"Estimated","Pending","Approved"},$G$40:$G$79))

Tags:

Best Answer

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Answer ✓
    Options

    Make sure you replace the columns names correctly and also the row numbers as appropriate in your sheet

    =SUMIF([Your Status Column Name]40:[Your Status Column Name]79, OR(@cell = "Estimated", @cell = "Pending", @cell = "Approved"), [Your Value Column Name]40:[Your Value Column Name]79) 
    

Answers

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Answer ✓
    Options

    Make sure you replace the columns names correctly and also the row numbers as appropriate in your sheet

    =SUMIF([Your Status Column Name]40:[Your Status Column Name]79, OR(@cell = "Estimated", @cell = "Pending", @cell = "Approved"), [Your Value Column Name]40:[Your Value Column Name]79) 
    
  • TW12345
    TW12345 ✭✭
    Options

    Awesome, THANK YOU Sameer. I was able to translate it over. Thank you so much for your help on this. Many Thanks again.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!