=COUNTA(A2:A12)
=COUNTIF(C2:C12,TRUE)
=COUNTIFS(A2:A12, '<>', C2:C12, TRUE)
Part/Total = Percentage
=COUNTIF(C2:C12,TRUE)/COUNTA(A2:A12)
=IF(B14=B15, 'Yep!', 'Nope :(')
=$C2=TRUE
=IF(E2=TRUE, 'Done', 'To Be Done')
=$C2='Done'
=IF(I2=TRUE, H2, '-')
=DSUM(A5:F48, 'sub-total', J1:J5)
=IFERROR(DSUM(A5:F48, 'sub-total', J1:J5), 0)
=IF($G$2=TRUE, B4, NA())
=IF($G$2=TRUE, C4, NA())
=$D4
, and copy it down to L7. Because the data for the year 2015 should always be displayed in the chart, an IF formula is not needed for this column.