+ Reply to Thread
Results 1 to 3 of 3

Using SUMIFS formula can a left formula be used

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    Des Moines, Iowa
    MS-Off Ver
    Office 365
    Posts
    43

    Using SUMIFS formula can a left formula be used

    In the attachment is a small sample of the data that I am wanting to use. I was using a Sumifs formula so that in B7 I would get the results of the total from K for Descriptions in I that matched Original Estimate and Approved est changes. I was able to do this if I took column A and split it into a number 213000, since this same number as in G. I was trying to figure out how I could leave it as is and have the sumifs, by doing a left function pull the same data.

    So in essence B7 and B8 are the fields where the formulas go. The estimate formula needs to be specific to the job number (12-05906) and the phase (213000) where the estimate equals the words Original Estimate and Approved est changes. Then in B8 should be a formula that pulls the same (job number)(phase), but then pulls from the description JC cost, AP cost & PR cost.

    So I was able to do this by breaking up the Phase & description (213000-Project Mgmt) into two fields and do the sumifs, I was curious how to do it if I didn't want to do it that way.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor PaulSP8's Avatar
    Join Date
    11-21-2017
    Location
    Chorley, England
    MS-Off Ver
    2013
    Posts
    390

    Re: Using SUMIFS formula can a left formula be used

    If I have understood correctly...

    B7;

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


    B8;

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

  3. #3
    Registered User
    Join Date
    05-15-2019
    Location
    Des Moines, Iowa
    MS-Off Ver
    Office 365
    Posts
    43

    Re: Using SUMIFS formula can a left formula be used

    This worked great. Thank you.

+ 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] sumifs formula to extract first left item based on Crteria
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-15-2019, 01:20 AM
  2. Formula to move data to Left when LEFT cell is blank?
    By wer5150 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2019, 05:26 AM
  3. Formula to move data to Left when LEFT cell is blank?
    By wer5150 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-31-2019, 05:22 AM
  4. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  5. Replies: 10
    Last Post: 12-16-2015, 03:16 PM
  6. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  7. SUMIFS Formula with LEFT Function
    By Sultix in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-18-2009, 06:43 AM

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