Sep 20 2022 11:13 AM
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
Sep 20 2022 11:22 AM