+ Reply to Thread
Results 1 to 9 of 9

Formula help (SumIf totals caculations COMPLETELY LOST!)

  1. #1
    Registered User
    Join Date
    08-05-2015
    Location
    Daytona Beach
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    10

    Formula help (SumIf totals caculations COMPLETELY LOST!)

    So, taking the easy way out came around to bite me in the butt. I had someone help me with the formulas for this excel sheet, now I need to make a change, and have no idea how to do it.

    Hopefully the sheet is pretty self explanatory but basically I need to subtract the 1099 column for each month (H24:H200) from the commission totals for each month (F2:F13) and place that value in a new column under TOTAL NET COMMISSIONS G2:G13

    For example, in October, there were two 1099 entries ($1,467.00 & $1,500.00)

    I need to add up the total 1099 value for each month and then subtract it from the month's total commission.

    Geez... I am rambling. If anyone has a clue as to what I need please help, or point me in the right direction! Thank you so much in advance! File attached.

    Attachment 435517
    Attached Files Attached Files
    Last edited by thekiddzac; 12-15-2015 at 08:36 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

    I may have missed the point but I just added two columns - see attached sample.
    Attached Files Attached Files
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    537

    Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

    If you wanted it all in the one column, then try this in cell F11:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-05-2015
    Location
    Daytona Beach
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    10

    Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

    Quote Originally Posted by tuph View Post
    I may have missed the point but I just added two columns - see attached sample.
    This would work, however for "ADJUSTED COMMISSIONS" it is showing $0.00 for any month without a "1099" value. Is there a formula I can put in there that doesn't depend on a value for 1099 but still calculates the ADJUSTED COMMISSIONS.

    I tried putting in 0 for all the 1099 that didn't have any and it still showed $0.00 for the ADJUSTED COMMISSION

  5. #5
    Registered User
    Join Date
    08-05-2015
    Location
    Daytona Beach
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    10

    Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

    Quote Originally Posted by Beamernsw View Post
    If you wanted it all in the one column, then try this in cell F11:
    Please Login or Register  to view this content.
    That worked perfectly, however, I'm now realizing seperated columns would be best "TOTAL COMMISSIONS", "TOTAL 1099", and "NET COMMISSIONS" so I can see exactly how much went to 1099 each month. It's the Months that mess me up. I can handle equations dealing with x to y but when i need to calculate the values based on months I'm lost. Even studying the equations, it's all greek to me!

    THANK YOU SO MUCH FOR RESPONDING THOUGH!

  6. #6
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    537

    Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

    In that case, use tuph's example and paste this formula into cell H2 and copy down:

    Please Login or Register  to view this content.
    Instead of 0.00 if G2 is blank, it uses the value of cell F2.

  7. #7
    Registered User
    Join Date
    08-05-2015
    Location
    Daytona Beach
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    10

    Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

    Quote Originally Posted by Beamernsw View Post
    In that case, use tuph's example and paste this formula into cell H2 and copy down:

    Please Login or Register  to view this content.
    Instead of 0.00 if G2 is blank, it uses the value of cell F2.
    THIS WILL WORK! lol thanks so much for contributing! Now when I have some free time, I promise I will try to learn WHY this all works.

    Thank you again everyone!!! It has been solved!

  8. #8
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    537

    Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

    you're most welcome

  9. #9
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

    Happy to be of assistance.

+ 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. Trouble with SUMIF formula on totals tab
    By hstiller in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2014, 02:32 PM
  2. Replies: 3
    Last Post: 03-29-2013, 12:09 PM
  3. Replies: 3
    Last Post: 11-16-2012, 01:23 AM
  4. Excel 2007 : COMPLETELY lost in VBA
    By DXP in forum Excel General
    Replies: 1
    Last Post: 06-05-2012, 04:31 AM
  5. Please help, i am completely lost
    By cozzienz in forum Excel General
    Replies: 3
    Last Post: 07-02-2011, 02:57 AM
  6. need urgent help: completely lost/stuck with vlookup issue
    By jimmyjj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2006, 10:35 PM
  7. completely lost
    By clueless in forum Excel General
    Replies: 4
    Last Post: 07-11-2005, 02:05 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