Sumifs Help with Month/Year and checkbox

10/31/19 Edited 12/09/19

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

Popular Tags:


Sign In or Register to comment.