Forum Discussion
BenMor40
Sep 20, 2022Copper Contributor
Trying to Calculate SUM IF output from multiple inputs
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
Sort By
- dscheikeyBronze Contributor