Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 2nd 20, 03:49 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2020
Posts: 1
Default Sum formula not working

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

  #2   Report Post  
Old September 3rd 20, 05:48 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 532
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A formula not working as the result of a previous formula? Ed[_7_] Excel Discussion (Misc queries) 5 July 21st 09 06:22 PM
Formula not working SD New Users to Excel 3 May 20th 08 07:07 PM
Formula Not working SD Excel Discussion (Misc queries) 1 May 20th 08 05:27 PM
Again for Formula that isn't working... jeannie v Excel Worksheet Functions 0 March 6th 08 02:41 AM
formula not working Micayla Bergen Excel Discussion (Misc queries) 13 May 23rd 05 01:48 PM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017