Sum formula not adding correctly

Karl86

I am trying to sum up columns but its giving me an output of zero when the total should be 25. Can anyone help?

Paul Newcome

The formulas that are populating the individual numbers will need adjusted. It looks like they are outputting text strings that just look like numbers. What are those formulas?

Karl86

@Paul Newcome thanks here are the formulas

User Business Value formula is

=IF(Priority@row = 1, "10", IF(Priority@row = 2, "5", IF(Priority@row = 3, "1")))

Risk Reduction formula is

=IF([Risk Reduction / Opportunity Enablement]@row = 1, "10", IF([Risk Reduction / Opportunity Enablement]@row = 2, "5", IF([Risk Reduction / Opportunity Enablement]@row = 3, "1")))

Time critical score formula is

=IF([Time Criticality]@row <= 30, "10", IF([Time Criticality]@row <= 60, "9", IF([Time Criticality]@row <= 90, "8", =IF([Time Criticality]@row <= 120, "7", IF([Time Criticality]@row <= 150, "6", IF([Time Criticality]@row <= 180, "5", =IF([Time Criticality]@row <= 210, "4", IF([Time Criticality]@row <= 240, "3", IF([Time Criticality]@row <= 270, "2", IF([Time Criticality]@row <= 300, "1"))))))))))

Paul Newcome

Try removing the quotes from around each of the output numbers.