I am having trouble getting the SUM of the output of a range of cells. These cells contain a IFERROR formula and then I want to SUM based on the output of the cells. When I try to SUM the range, it takes the information in the formula and sums that information instead of the output of the cell's formula.
Formula of the Cells I want to SUM: =IFERROR(IF(G9<30,"<30 DAYS",IF(G9<60, "<60 DAYS", IF(G9<90, "<90 DAYS", IF(G9<180, "< 6 MONTHS", IF(G9<365, "< 1 YEAR", IF(G9<730, "<2 YEARS","")))))),"")
Formula I am using to SUM the cells: =SUMIF($H4:$H114, "<30 DAYS", $N4:$N114) where the N range is how much to SUM (1).
The SUM formula then returns 110 because that's how many cells I'm trying to count and the formula in those cells has "<30 DAYS" in side the formula.
What is the workaround so that it SUMS the OUTPUT of the cells, not what's in the formula in those cells? Or am I doing something else incorrectly?
Thank you for your assistance!
Formula of the Cells I want to SUM: =IFERROR(IF(G9<30,"<30 DAYS",IF(G9<60, "<60 DAYS", IF(G9<90, "<90 DAYS", IF(G9<180, "< 6 MONTHS", IF(G9<365, "< 1 YEAR", IF(G9<730, "<2 YEARS","")))))),"")
Formula I am using to SUM the cells: =SUMIF($H4:$H114, "<30 DAYS", $N4:$N114) where the N range is how much to SUM (1).
The SUM formula then returns 110 because that's how many cells I'm trying to count and the formula in those cells has "<30 DAYS" in side the formula.
What is the workaround so that it SUMS the OUTPUT of the cells, not what's in the formula in those cells? Or am I doing something else incorrectly?
Thank you for your assistance!