ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sum formula not working (https://www.excelbanter.com/excel-worksheet-functions/454932-sum-formula-not-working.html)

SAM HO September 2nd 20 03:49 PM

Sum formula not working
 
On Google Docs, I use the formula =sum(E29:F29) press enter, result = 0
Always, any reason why?
Help please.

Auric__ September 3rd 20 05:48 AM

Sum formula not working
 
SAM HO wrote:

On Google Docs, I use the formula =sum(E29:F29) press enter, result = 0
Always, any reason why?
Help please.


(Google Docs is *not* Excel.)

Without seeing your spreadsheet, we can't diagnose the problem. My first
thought is that you have numbers entered as text.

--
Base not your joy on the deeds of others,
for what is given can be taken away.
-- Peter Steele


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com