Adding a column that has IF fomulas

Hi, 

Your problem is:

These numbers are considered as texts, so SUM ignored them, and returns 0 since there are no numbers to add!

You can check that by using ISTEXT function, just apply it to one of these numbers, and you will get TRUE.

The solution is:

Convert these text numbers to actual numbers by using one of the following methods:

#1

Go to the last of the IF function after the right parenthesis and type: +0

=IF(logical_test,value_if_true,value_if_false)+0

 Then apply this update to all existing cells.

#2

Replace this formula:

=SUM(C4:C78)

With this:

=SUMPRODUCT(VALUE(C4:C78))

Hope that helps.