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!