Results 1 to 11 of 11

Summing commission totals by month.

Threaded View

  1. #1
    Registered User
    Join Date
    08-18-2013
    Location
    NOLA, LA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Summing commission totals by month.

    Need help creating an Excel formula for adding commission income depending on who the salesperson is and the month in which the commission was received.

    A B C D
    1 MONTH COMMISSION MONTH TOTALS
    2 Jan $1,000 January
    3 Feb $2,000 February
    4 Jan $100 March
    5 Feb $100 April
    6 Mar $2,000 May
    7 Jan $400 June


    In the cells above is a sample of what the sheet looks like. I like to figure out this:
    • If cell A2 says “Jan” then take the dollars amount adjacent at B2 and put it in cell C2 (total Jan Income)
    • If cell A4 says “Jan” again, then take the dollar amount adjacent at B4 and add it to the amount that is already at C2 (total income for Jan)

    I’ve tried using “If then” formulas, but just can’t see to get it right.

    Can anyone help?

    Albert Allegue
    Last edited by allegue; 08-18-2013 at 05:59 PM. Reason: Inadequate title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hi Member since long but posting for the first time.
    By garilou in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-06-2012, 01:42 AM
  2. Old member posting for the first time
    By garilou in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-16-2012, 01:10 AM
  3. I won't be posting help here for a long time
    By royUK in forum The Water Cooler
    Replies: 5
    Last Post: 08-23-2012, 10:54 AM
  4. Excel 2007 : Vacation Accruals:first time posting
    By maine32 in forum Excel General
    Replies: 0
    Last Post: 07-23-2010, 12:00 PM
  5. [SOLVED] New here so be gentle
    By James D. Connelly in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-18-2005, 08:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1