1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

issues with Excel formulas

Discussion in 'Business Applications' started by cohibasmith, Feb 21, 2017.

Thread Status:
Not open for further replies.
  1. cohibasmith

    cohibasmith Thread Starter

    Joined:
    Feb 21, 2017
    Messages:
    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. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,904
    First Name:
    Wayne
    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
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Tags:
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1185724

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice