Tech Support Guy banner
Status
Not open for further replies.

issues with Excel formulas

Tags
excel 2013
720 views 1 reply 2 participants last post by  etaf 
#1 ·
I have a pricing spreadsheet that I am working with and sometimes when I try and do a sum of three different column totals which have already been individually added up =sum(B2, C2, D2) as an example, Sometimes, I will get a blank cell after hitting the enter button and sometimes I will not. Does that make sense?



Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i5-4440 CPU @ 3.10GHz, Intel64 Family 6 Model 60 Stepping 3
Processor Count: 4
RAM: 8064 Mb
Graphics Card: Intel(R) HD Graphics 4600, -1984 Mb
Hard Drives: C: 452 GB (232 GB Free); F: 931 GB (690 GB Free);
Motherboard: ASUSTeK COMPUTER INC., B85M-E
Antivirus: Symantec Endpoint Protection, Enabled and Updated
 
#2 ·
not really
sum(B2: D2)
is the same
OR
=B2+C2+D2

see what they give you

Sounds like the Auto calc is maybe doing a lot of work and not quite summing
whats in B2, C2 , D2
a number or another calc ?

perhaps upload a sample sheet here
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top