Tech Support Guy banner

issues with Excel formulas

679 Views 1 Reply 2 Participants Last post by  etaf
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
Status
Not open for further replies.
1 - 2 of 2 Posts
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
See less See more
1 - 2 of 2 Posts
Status
Not open for further replies.
Top