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

TW12345

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))

Sameer Karkhanis

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) 

Sameer Karkhanis

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

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