If C = 1 then or If C = 2 or 3 (>) then add those monetary amounts for a sum total
=IF(C2:C73=1,SUM('November FY2017 - Q1'!K2:K73+'November FY2017 - Q1'!K2:K27),"")
AND
=IF(C2:C73>1,SUM('November FY2017 - Q1'!K2:K73+'November FY2017 - Q1'!K2:K27),"")
The results would be a dollar amount - I have the formula I use for the Row but can get the column to calculate properly.
Value Received: #VALUE!
Thank you for any information you can provide with this issue.