I have this long drawn out if formula that I know can be simplified. If anyone can assist, that would be great
=IF('ASA Levels'!$N$4="TRUE",SUM(C12:N12),IF('ASA Levels'!$M$4="TRUE",SUM(C12:M12),IF('ASA Levels'!$L$4="TRUE",SUM(C12:L12),IF('ASA Levels'!$K$4="TRUE",SUM(C12:K12),IF('ASA Levels'!$J$4="TRUE",SUM(C12:J12),IF('ASA Levels'!$I$4="True",SUM(C12:I12),IF('ASA Levels'!$H$4="True",SUM(C12:H12),IF('ASA Levels'!$G$4="True",SUM(C12:G12),IF('ASA Levels'!$F$4="True",SUM(C12:F12),IF('ASA Levels'!$E$4="True",SUM(C12:E12),IF('ASA Levels'!$D$4="True",SUM(C12:D12),IF('ASA Levels'!$C$4="True",SUM(C12:C12),""))))))))))))
The gist of the formula is that if a month comes back "True" to sum that month and all of the prior months to get a YTD value.
Thanks
=IF('ASA Levels'!$N$4="TRUE",SUM(C12:N12),IF('ASA Levels'!$M$4="TRUE",SUM(C12:M12),IF('ASA Levels'!$L$4="TRUE",SUM(C12:L12),IF('ASA Levels'!$K$4="TRUE",SUM(C12:K12),IF('ASA Levels'!$J$4="TRUE",SUM(C12:J12),IF('ASA Levels'!$I$4="True",SUM(C12:I12),IF('ASA Levels'!$H$4="True",SUM(C12:H12),IF('ASA Levels'!$G$4="True",SUM(C12:G12),IF('ASA Levels'!$F$4="True",SUM(C12:F12),IF('ASA Levels'!$E$4="True",SUM(C12:E12),IF('ASA Levels'!$D$4="True",SUM(C12:D12),IF('ASA Levels'!$C$4="True",SUM(C12:C12),""))))))))))))
The gist of the formula is that if a month comes back "True" to sum that month and all of the prior months to get a YTD value.
Thanks