+ Reply to Thread
Results 1 to 3 of 3

Two Running Balance Columns with Conditions

  1. #1
    Registered User
    Join Date
    02-13-2021
    Location
    Minnesota
    MS-Off Ver
    365
    Posts
    6

    Two Running Balance Columns with Conditions

    Good Afternoon

    I have a spreadsheet that calculates a Running Balance for Cash (formula in the spreadsheet, attached). But I need to base the running balance on conditions for two different columns. First, the Cash running balance column (Col F) should only calculate if the Description (Col E which is a dropdown list) selected is everything BUT Gift Cards. Now the Gift Card running balance (Column G no formula) should only calculate a running balance if the Description (Col E dropdown list) selected is ONLY Gift Cards.

    I can figure out the running balance, but not with conditions.

    I appreciate all your help.

    Marby
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Two Running Balance Columns with Conditions

    Cash:
    Please Login or Register  to view this content.
    G.C.
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Two Running Balance Columns with Conditions

    IN G3 then copied down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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. [SOLVED] running balance %
    By makinmomb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2019, 08:48 AM
  2. IF function for running balance that wont show starting balance in all cells
    By Heather T in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-11-2015, 03:15 PM
  3. [SOLVED] Running Balance
    By Sandyshirl in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 04-21-2011, 07:36 AM
  4. Running balance
    By meddyliol in forum Excel General
    Replies: 4
    Last Post: 07-03-2010, 11:27 AM
  5. Running balance
    By Greydon in forum Excel General
    Replies: 12
    Last Post: 04-28-2010, 12:49 PM
  6. to keep a running balance
    By johnilee in forum Excel General
    Replies: 2
    Last Post: 04-18-2006, 02:20 AM
  7. [SOLVED] rent received/balance owed/running balance spreadsheet
    By Quickbooks dummy in forum Excel General
    Replies: 1
    Last Post: 01-02-2006, 03:40 PM

Tags for this Thread

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