Help w/ #INCORRECT ARGUMENT SET

Options

Below is the formula that I currently have in place but it is giving me #INCORRECT ARGUMENT SET.

=SUMIFS({Estimating Range 1}, "Civil", {Estimating Range 3}, 9, {Estimating Range 4}, 2020, {Estimating Range 2})


I am trying to use a SUMIFS formula to capture a dollar value as stated in Estimating Range 2. But I am only wanting to get the totals for this range that meet the following requirements: Is marked Civil in Estimating range 1, Has the month of 9 in Estimating Range 3 and has the year of 2020 in Estimating Range 4.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!