Results 1 to 2 of 2

Thread: Calculatiing Formula

  1. #1

    Calculatiing Formula

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Morning All,

    I have a Cash sheet with totals on it but I can not figure something out.

    When entering 1.50 into K6, L6 shows 1.50
    When entering 2.00 into K7, L7 shows 3.50 and so on, but I do not want to see 3.50 in all the cells in L but when I enter figures into the other cell I want the L column to change to the new calculation and so on.

    L39 will show the sum of column K. I hope this makes sence, I am not very good at explaining things. I have attached a copy of the cash sheet to hopefuly explain it self.

    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    First of all, when picking up a single cell, you do not need to use SUM, you can reference the cell directly. So in L6 do not use =SUM(K6), just use =K6.

    Then, when you do add multiple cells, you do not need SUM and +, the + sums the element, so one or the other suffices. So instead of =SUM(L6+K7), use =SUM(L6,K7) or =L6+K7.

    To your problem, use this in L7


    and copy down. In words, you test if K7 is blank, if so return a blank into the cell, otherwise do the sum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts