How to SUMIF in Smartsheet with multiple criteria requirements from one column
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))
Best Answer
-
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
-
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)
-
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
Categories
Check out the Formula Handbook template!