+ Reply to Thread
Results 1 to 7 of 7

Please help with "IF" formula

  1. 08-20-2015, 02:27 PM #1
    stacey nichole is offline
    Registered User
    Join Date
    08-20-2015
    Location
    California
    MS-Off Ver
    2013
    Posts
    3

    Unhappy Please help with "IF" formula

    I have a spreadsheet that I use for my construction company to keep track of what managers are on what jobs and how much profit our jobs are making.

    In column A it has my manager's names
    In column B it has my job names
    Column C has my contract amount
    Column D has the total amount we've billed
    Column E has the total cost on the job
    And Column F is my gross profit percentage

    I would like this formula I'm placing under my spreadsheet to say "If Hector was the manager, this is the total of his job costs" and have the formula grab every contract amount in Column C that Hector was the manager on.

    =IF(A2:A67="HL",C2:C67) ---- This is my attempt and it didn't work.

    Please help me Trying to figure out if these guys deserve a raise or not.
    Reply With QuoteRegister To Reply
  2. 08-20-2015, 02:29 PM #2
    bhenlee is offline
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    633

    Re: Please help with "IF" formula

    try this:

    =SUMIF(A:A,"HL",C:C)

    let me know if I deserve i raise
    If I've helped U pls click on d *Add Reputation
    Reply With QuoteRegister To Reply
  3. 08-20-2015, 02:31 PM #3
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Please help with "IF" formula

    Hi, welcome to the forum

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 08-20-2015, 02:32 PM #4
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Please help with "IF" formula

    Waiting for Mod
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  5. 08-20-2015, 02:32 PM #5
    stacey nichole is offline
    Registered User
    Join Date
    08-20-2015
    Location
    California
    MS-Off Ver
    2013
    Posts
    3

    Re: Please help with "IF" formula

    Bhenlee, you're incredible! Thanks so much for your help!!
    Reply With QuoteRegister To Reply
  6. 08-20-2015, 02:33 PM #6
    stacey nichole is offline
    Registered User
    Join Date
    08-20-2015
    Location
    California
    MS-Off Ver
    2013
    Posts
    3

    Re: Please help with "IF" formula

    Thank you ChemistB!!!!!
    Reply With QuoteRegister To Reply
  7. 08-20-2015, 02:34 PM #7
    bhenlee is offline
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    633

    Re: Please help with "IF" formula

    glad it work but please comply with the requested changes by our moderators..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  3. [SOLVED] How to short my formula which is ="("&a1&","&a2&","&a3&","&a4&" end in "&a200&")
    By vengatvj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-07-2013, 07:49 PM
  4. [SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes
    By andreindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2013, 05:49 PM
  5. Formula returning result of "True" or "False" instead of "1" or "0"
    By AllenMead in forum Excel General
    Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  6. Trouble with "and" "if" and "or" functions in excel Formula
    By Markshr in forum Excel General
    Replies: 3
    Last Post: 08-28-2010, 09:31 AM
  7. Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
    By BCB in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-13-2006, 05:02 PM
  8. [SOLVED] If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1