ExcelBanter - SUM ERROR

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUM ERROR (https://www.excelbanter.com/excel-worksheet-functions/79797-sum-error.html)

Thorne

SUM ERROR

When I type the formula =sum(f2:f4) I get 0 as an answer. The cells F2, F3
and F4 have numbers in them. What is wrong?

Gary''s Student

SUM ERROR

Make sure the "numbers" are not just text. The SUM() function ignores text.
--
Gary's Student

"Thorne" wrote:

When I type the formula =sum(f2:f4) I get 0 as an answer. The cells F2, F3
and F4 have numbers in them. What is wrong?

All times are GMT +1. The time now is 02:04 AM.