+ Reply to Thread
Results 1 to 2 of 2

Setting a specific number to a cell where the other numbers in the columns will substract

  1. #1
    Registered User
    Join Date
    11-02-2022
    Location
    World
    MS-Off Ver
    Office 365 (Version 2209 Build 15629.20208
    Posts
    1

    Question Setting a specific number to a cell where the other numbers in the columns will substract

    First of all, I know nothing about Excel and this is pretty much the first time I am using it.

    How can I set a rule about this?

    I set the number 12 to a column for instance.

    Then I write 5 to the second row of the same column.

    I want 5 to be subtracted from 12 then the value will be shown in the sum row (Not in the same row.)

    Like this:

    B Column = 12

    B Column, 1st Row = 5 (12-5 = 7)

    B Column, 2nd Row = 15 (12-15 = -3)

    B Column Sum Row = 4 (7 -3)

    Thanks in advance. Sorry for my English.

    I found the solution with a help with adding this formula:

    =number*COUNT(B:B)-SUM(B:B)

    Problem solved
    Last edited by SweetScore; 11-02-2022 at 09:58 AM.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Setting a specific number to a cell where the other numbers in the columns will substr

    Removed by FR.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 07-06-2022, 04:49 PM
  2. [SOLVED] substract if the value in specific cell more than specific number in other cell
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-04-2016, 09:50 PM
  3. [SOLVED] How to substract two dates columns and count for specific days
    By Zuluwaco in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-26-2015, 10:53 AM
  4. vb code for receive button to substract textBox value from specific cell of sheet
    By swapbhay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-21-2013, 09:28 AM
  5. Hide specific columns dependant on number in specific cell
    By ladbroke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2012, 04:46 PM
  6. Replies: 8
    Last Post: 05-19-2009, 03:03 AM
  7. [SOLVED] How do I substract numbers in range like this: Substract(a1..a10)
    By Paulo in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-17-2005, 12:50 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1