+ Reply to Thread
Results 1 to 2 of 2

Total Billed Formula and Remaining formula

  1. #1
    Registered User
    Join Date
    03-24-2021
    Location
    Texas
    MS-Off Ver
    365
    Posts
    1

    Total Billed Formula and Remaining formula

    I'm new to excel and I have been tasked to build an excel file to cover job status and billing. I can get most of the stuff working with basic formulas like Sumif and others along with basic VBA. Problem is I cant figure out formula to get total billed from sheet and then formula to show remaining after billed thru here. Basically how would I go about summing after a phrase for example. In the sheet it says "Billed Through Here" So anything after that depending on job would be summed separately. Hope fully I explaining right. I don't even know if its possible thought I would ask since most of what I learned came from the forums here. The Sheet is the JobInfo sheet.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Total Billed Formula and Remaining formula

    Welcome to the forum.

    Maybe this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Good luck!

+ 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] Need to fix formula so running total in HR Remaining column is not a negative number
    By Sunny625 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-04-2017, 02:18 AM
  2. [SOLVED] Multiplying the results of two columns of sums - Total Billed and Total Paid
    By stuprice in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-02-2017, 04:23 PM
  3. Replies: 7
    Last Post: 11-28-2015, 02:38 PM
  4. [SOLVED] Formula to calculate remaining vacation days from total
    By Tricia0923 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2015, 10:17 PM
  5. Time * Rate = Amount Billed Formula?
    By Andrew Eagles in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2006, 05:55 PM
  6. [SOLVED] Time * Rate = Amount Billed Formula?
    By Andrew Eagles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-12-2006, 01:36 PM
  7. [SOLVED] Total remaining formula
    By jbsand1001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2005, 01:06 PM

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