Trying to Calculate SUM IF output from multiple inputs

Occasional Visitor



I am trying to calculate a SUMIF output from multiple inputs and conditions, looking for help in writing this formula.

In column 'H', if column 'C' specifies Annual or Trennial specification then I would like the year in column 'F' to add 1 or 3. 

This first part of the formula [SUM(IF(C3="Annual",F3+1,0))] works, but the second part of the formula is not calculated. 



Thank you,


1 Reply



should work!