Trying to Calculate SUM IF output from multiple inputs

Occasional Visitor

Hello, 

 

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. 

=SUM(IF(C3="Annual",F3+1,0))+SUM(IF(C3="Trennial",F3+3,0))

 

Thank you,

Ben

1 Reply

@BenMor40 

=SUM(F3,IF(C3="Annual",1,0),IF(C3="Trennial",3,0))

should work!