# 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

• ✭✭✭✭✭✭
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

• ✭✭✭✭✭✭
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)
```
• ✭✭
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!