Sumifs Help with Month/Year and checkbox

JNull
JNull
edited 12/09/19 in Formulas and Functions

I keep getting an error when writing this formula.  Can someone please help?

I want to sum the "Weighted Range" when "Prob Closing" is checked (1), and "Close Date" is January (1) of 2020.

The 3 columns are in another spreadsheet.  

=IFERROR(SUMIFS({Weighted Range}; {Prob Closing}, 1; {Close Date}; MONTH(@cell) = 1; {Close Date}; YEAR(@cell) = 2020); 0))

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!