Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-12-2016, 02:07 PM
MikeM3 MikeM3 is offline Addition Formula is Giving a Date!!! Windows 10 Addition Formula is Giving a Date!!! Office 2003
Novice
Addition Formula is Giving a Date!!!
 
Join Date: Jan 2016
Posts: 5
MikeM3 is on a distinguished road
Default

Quote:
Originally Posted by Kevin@Radstock View Post
Hi Mike

The cell which has the formula in, is it General formatting and not as a date!
Hi Kevin, thank you for reading this.

I think it is general formatting.

Columns "A" to "G" are on the income side, with "A" being
the Date and G being the total, "B" to "F" are the income
streams.

Te formula =SUM(B4:F4) is in the "G" column, but it is not
doing the job.

There must be some hidden text or instructions in that cell
I think.

If all fails, I will just have to start with a fresh spreadsheet,
I tried to help myself by using an old one, but deleted all the
formula in the cells, so a fresh sheet will be clean.

Mike.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Addition Formula is Giving a Date!!! Formula to return a date caz46 Excel 3 04-15-2015 08:59 AM
Addition Formula is Giving a Date!!! Date specific formula Query Mukiwi Excel 4 03-20-2014 06:33 AM
Addition Formula is Giving a Date!!! VLookup is giving me #N/A error, help with data or formula? ladygogo78 Excel 3 10-22-2012 12:28 AM
Index Addition Leaves Hidden Codes On SQLUSA Word 3 07-23-2012 02:58 AM
Addition Formula is Giving a Date!!! Need a date formula MPAVLAS Excel 3 08-12-2010 10:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft